[dba-SQLServer] Indexing on a small number of values in a column

artful at rogers.com artful at rogers.com
Thu Dec 14 23:19:42 CST 2006

I have heard or read that creating an index on a column containing a small number of values is pointless.

a) Given a column Sex with a constraint "M/F", is there any point indexing this column?
b) Given the same column defined as a bit, you can't index it (afaik).
c) Assuming that it is pointless to index a column containng < n distinct values, what is the value of n? Assume 100M rows in the table of interest?


More information about the dba-SQLServer mailing list