How do I create an index on a table that is non unique?
- by RoboShop
I want an index on a non-primary key column, but this column may have nulls in it. I find on a normal unique index, it (rightly so) only allows one null.
Is that possible?
and what is the syntax for this?