Subject How to use Statistics for Index creation
Author rjschappe
I have been slowly adding new indicies on columns + PrimaryKey and it
has really helped in the speed of many of my queries...(Thanks a ton
Helen!!! :-)

Now, I am trying to determine just how many of these highly selective
indices I should use...

I have run the statistics on my tables and I see many columns of the
indices on my Foreign Keys have a high percentage of total dups and
max dups... but just how high is too high???

I do not want to start ripping out lots of my FK Constraints and
replacing them with Check Constraints + the new highly selective
indices... unless it will really help.

Are there any guidelines or rules to follow to help me determine
which of these FK indices I should replace?