© Copyright, 2002 Howard F.
Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
Index Selectivity
•The selectivity of an index
controls whether the optimizer will think using that
index is a good idea
•Selectivity can be found by looking at the
key loading information from the DSPFD command
•Use my selectivity
report, SQLThing Enterprise Edition, to
understand how selective an index is