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
When would you use a before or after trigger?
How real and float literal values are rounded?
What is triggers in ms sql server?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How to optimize stored procedures in sql server?
What is table level trigger?
What are the steps you will take to improve the performance of a poor performing query?
What are the disadvantages of indexes?
what is the difference between Tabular and Matrix report?
What is full outer join in sql server joins?
What is indexing in sql server with example?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How do I setup a sql server database?
Tell me what is de-normalization and what are some of the examples of it?
Explain the difference between cross join and full outer join?