Unique key column by default creates a non-cluster index on the column. Primary key creates cluster index on the column. The only difference is Unique key column allows only one null value. So is it possible to have cluster index on Unique key column?
The answer is YES. Though Unique key allows null value but it still maintains the uniqueness of the column.
Asked In: Many Interviews |