Forum Post: RE: Difference between logical reads and record reads

  • Thread starter Thread starter ChUIMonster
  • Start date Start date
Status
Not open for further replies.
C

ChUIMonster

Guest
PRIMARYness isn't necessarily good. The quality of the bracket is what matters. How well do the WHERE clause and the indexes match? PRIMARY is a tie-breaker, not a goal. If the WHERE clause and the indexes are not 100% equality matches then the expected ratio should be expected to be higher than 2:1 because there will be filtering of the result set which means excess reads.

Continue reading...
 
Status
Not open for further replies.
Back
Top