• Excellent article.

    One of the few I have seen which mentioned the selectivity guidelines for non clustered indexes.

    Yes it is a good reason to drop an index if a single value returns more than 10-15% of the table.

    David Branscome