Indexes
711094Apr 9 2010 — edited Apr 9 2010Hi all,
I think about if it does make sense to create an index on a column which only allows 2 different values. Here is my statement:
SELECT DISTINCT netz_nr
FROM adressen
WHERE ebene = nsp
In the column "ebene" of the table "adressen" are only the entries "nsp" or "msp", so does it makes sense with an index???
Thanks in advance! :-)
Colt