mauryakamal (4/14/2009)
1) Is it unique index is cluster index or non cluster index?2) If we define the unique index column not null then what type of the index.
3) If unique index column is null then what type of the index???
Please elaborate about the unique index.
Thanks in advance.
Answer to Question 1) ==> it can be either way. When you create a primary Key it creates the Unique Clustered Index. When you create Unique Key it creates the Non-Clustered Index.
Answer to Question 2) ==> Non-Clustered Index.
Answer to Question 3) ==> Non-Clustered Index.
Check out the below link on Unique Index
http://msdn.microsoft.com/en-us/library/ms187019.aspx