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
How do I create a partition table in sql server?
Explain microsoft sql server functions?
when you create a database how is it stored? : Sql server database administration
How do I find the size of a sql server database?
What is save transaction and save point?
Do you think BCNF is better than 2NF & 3NF? Why?
A trigger can reference objects outside the current database? State true or false.
What is nonclustered index with included columns ?
How to store and query spatial data?
Explain unique key in sql server?
Define indexes?
Explain candidate key, alternate key, and composite key?
What is @@error in sql?
How to use subqueries with the in operators in ms sql server?
What is command parameter in ssrs?