View Single Post

   
  #3 (permalink)  
Old 02-26-2008, 07:56 PM
Bruce Pullen
 
Posts: n/a
Default Re: Table scans for larger rowcounts?

No, but those indexes with lower cluster ratios are being scanned?!?

INDNAME CLUSTERFACTOR
------------------ ------------------------
XAK1INTRL_MSG_Q +1.00000000000000E+000*
XIE1INTRL_MSG_Q +9.99159663865546E-001*
XIF11168AINTRLMSGQ +1.00000000000000E+000
XIF11168BINTRLMSGQ +7.77310924369748E-001
XIF1196INTRL_MSG_Q +8.84033613445378E-001
XIF1265INTRL_MSG_Q +7.77310924369748E-001
XPKINTRL_MSG_Q +1.00000000000000E+000

INDNAME CLUSTERFACTOR
------------------ ------------------------
XAK1INTRL_MSG_Q +9.80784161490683E-001
XIE1INTRL_MSG_Q +9.99320652173913E-001
XIF11168AINTRLMSGQ +9.80784161490683E-001
XIF11168BINTRLMSGQ +6.24805900621118E-001
XIF1196INTRL_MSG_Q +7.69701086956522E-001
XIF1265INTRL_MSG_Q +6.34025621118012E-001
XPKINTRL_MSG_Q +9.80784161490683E-001

*Those indexes being scanned.
Reply With Quote