Can we create clustered index on non primary key column
Answer Posted / durgaprasad
no its not possible to place clustered index on non key
column once the table contains any one key column, bcoz key
column itself contains one clustered index based on that
data sorted in ascending order.if u place one more
clustered index how it is possible to arrange the data in
soreted order.
| Is This Answer Correct ? | 15 Yes | 29 No |
Post New Answer View All Answers
What are distinctive joins find as a part of sql?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is partition, how will you implement it? : sql server analysis services, ssas
How would you add a section to a table?
Why do you need a sql server?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How to disable triggers using "disable trigger"?
What are the advantages of using stored procedures?
What are the advantages of passing name-value pairs as parameters?
What is the difference between varchar and varchar types?
How to create sub reports?
Explain transaction server auto commit?
What is checkpoint in sql server?
What is transaction server distributed transaction?
How to delete an existing database user?