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. |