Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 962
  • Last Modified:

logical vs physical reads

what is the difference between logical reads and physical reads?
0
yanci1179
Asked:
yanci1179
  • 2
  • 2
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
physical reads means the data has been read from disk into memory
logical reads means the the data was already in memory

1 logical reads means 1 page of data, ie 8KB
0
 
yanci1179Author Commented:
i read that in books online....but it didn't really mean much.  Ideally which one should be lower?
0
 
Brendt HessSenior DBACommented:
In a perfect world, physical reads would be equal to the number of data blocks in your database, and all other reads would be logical.  So, by preference logical reads should be the higher of the two.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
perfectly, the physical reads should be 0. also, logical reads as low as possible.
0
 
yanci1179Author Commented:
let me see if I understand this logical data read from what is already in cache.  if it's not there then it has to read the physical tables and retrieve the data?
0
 
Brendt HessSenior DBACommented:
Absolutely correct.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now