Is it possible to create Cluster Index on Unique Key Column?

 Posted by Virendradugar on 9/7/2009 | Category: Sql Server Interview questions | Views: 6415

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 | Alert Moderator 

Comments or Responses

Login to post response