Can we create clustered index on non primary key column

Answer Posted / grish varshney

yes, we can create the cluster index on non prime attribute
if it is unique & there is no prime attribute bcoz the
cluster index should be once..

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I create a partition table in sql server?

471


Explain microsoft sql server functions?

518


when you create a database how is it stored? : Sql server database administration

473


How do I find the size of a sql server database?

466


What is save transaction and save point?

605






Do you think BCNF is better than 2NF & 3NF? Why?

757


A trigger can reference objects outside the current database? State true or false.

532


What is nonclustered index with included columns ?

527


How to store and query spatial data?

538


Explain unique key in sql server?

516


Define indexes?

583


Explain candidate key, alternate key, and composite key?

559


What is @@error in sql?

604


How to use subqueries with the in operators in ms sql server?

539


What is command parameter in ssrs?

118