Click here to Skip to main content
14,218,216 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi,

I have some confusion regarding sql server indexing. I have searched in google this topic and gone through multiple blogs but still it's not clear for me.

My question is, can i create a cluster index based on multiple column and these columns are not a primary or unique key.
Posted
Rate this:
Please Sign up or sign in to vote.

Solution 1

Hi,

Check this...Difference between clustered and non clustered index in sql server[^]

Hope this will help you.

Cheers
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

If you created a Primary key for any column like studentId will create a clustered for studentId Column .
A table can have only one Primary key and Clustered Index.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100