Can we create clustered index on non primary key column
Answer Posted / venkat
yes we can create clustured index on non primary key,
But that column has unique values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Does table partitioning improve performance?
Explain what are page splits? : SQL Server Architecture
What do you understand by replication in sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to include date and time values in sql statements?
What is extent? Types of extents?
What are the restrictions while creating batches in sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
List all the types of user-defined functions?
What is raid, and how it can influence database performance?
Explain about analysis services?
what is the information that can be stored inside a bit column? : Sql server database administration
When would you use a before or after trigger?
What do you mean by subquery?
What is the advantage of sql server?