Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Leo Peysakhovich Index Creation Guidelines RE: Index Creation Guidelines
David Branscome
Old Hand
Points: 356
More actions
June 17, 2004 at 11:04 am
#510901
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.