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
Will sql server 2005 allow you to reduce the size of a column?
Name few endpoints exposed by ssrs 2012?
Do you know what are acid properties of transaction?
How do we synchronize On-Premise SQL server with SQL Azure?
What are the steps you can take to avoid “deadlocks”?
Explain what are commit and rollback in sql?
Define right outer join?
What are the grouping functions?
Tell me the difference between clustered and non-clustered index?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is Federation and Federation Member?
How to make a remote connection in a database?
Define candidate key, alternate key, and composite key.
Why do we use stored procedures in sql server?
How to list all field names in the result set using mssql_field_name()?