Indexing A Column With Just One Distinct Value (All The Madmen)

(Richard Foote) When one thinks about a column that might benefit from being indexed, one generally considers columns with lots of different values so that the selectivity of the column is such that relatively few rows get selected, making the index appealing to the cost based optimizer.

Read More - Register for Free Membership