Click here to Skip to main content
15,940,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

Hi,

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

Hope this will help you.

Cheers
 
Share this answer
 
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.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900