How do I create an index on a table that is non unique?

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 开发者_Python百科so) only allows one null.

Is that possible?

and what is the syntax for this?

CREATE INDEX idxname ON table(col1);

See MSDN