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 sql server use java?
How can sql server instances be hidden? : sql server security
How to send email from database?
tell me the disaster recovery plan
Is sql server 2016 free?
What are the differences between stored procedure and view in sql server?
What is a group function explain with an example?
What is the Main Difference between ACCESS and SQL SERVER?
Determine when to use stored procedure to complete sql server tasks?
Which are the important points to note when multilanguage data is stored in a table?
can a table be moved to different filegroup? : Sql server administration
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is the dbcc command and why is it used?
Find columns used in stored procedure?
What have included columns when we talk about sql server indexing?