Can we create clustered index on non primary key column
Answer Posted / kaveri
Clustered index can be created in non primary key column
but the primary key column shoulb be created with non
clustered index. because by default primary key will have
clustered index. Each table should have only one clustered
index. So first we have to remove clustered index from
primary key column by creating it with non clustered index
and then create clustered index for non primary key column.
Note: The non primary key column should contain unique
values
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a unique key and primary key?
Explain unique key in sql server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What different steps will a sql server developer take to secure sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
do views contain data ?
What is the purpose of a table?
explain different levels of normalization? : Sql server database administration
List the advantages of using stored procedures?
What are the common performance issues in sql server?
What are a scheduled jobs or what is a scheduled tasks?
What is subquery? Explain the properties of a subquery?
What is xdr?
Other than truncate statement, which other command can by-pass the trigger on the tables?
How to convert a unicode strings to non-unicode strings?