Can we create clustered index on non primary key column
Answer Posted / laxman2610
Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
Does windows server 2016 come with sql server?
Do you know hot add cpu in sql server 2008?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is difference between order by and group by?
what are the three command line utilities and what are their primary functions?
Why variables called the most powerful component of ssis?
What is the data type of time?
Define cross join in sql server joins?
What is view in sql?
What are the advantages of paper records?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain alternate key, candidate key and composite key in sql server?
What is always encrypted?
Write a SQL query to delete a table?
What is difference between count (*) and count column?