Reads

  • Hi all,

    Can anybody let me know the difference between logical and physical read?

    Thanks

  • Per Books Online:

    logical reads

    Number of pages read from the data cache.

    physical reads

    Number of pages read from disk.

    It's under "SET STATISTICS IO".

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply