View Single Post

   
  #4 (permalink)  
Old 02-26-2008, 07:57 PM
AK
 
Posts: n/a
Default Re: Table scans for larger rowcounts?

well, the cluster factors are almost identical.
what about the percentage of rows that satisfy the criteria?

For instance, if the query uses an index and returns 50 rows out of 1K
(0.5%), using an index is justified.
If the same query scans the 10K table and returns 8500 rows out of 10K
(85%), that optimizer's choice to scan the table also makes perfect
sense
Reply With Quote