Can we create clustered index on non primary key column
Answer Posted / vidit
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 ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the basic functions for master, msdb, model, tempdb databases?
What is the difference between DATETIME2 and DATETIME?
When a primary key constraint is included in a table, what other constraints does this imply?
When would you use a before or after trigger?
What are alternate keys?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Define self join in sql server joins?
Define union, union all, minus, intersect?
How to find table changes in sql server?
What is the full form of dql?
How to apply cascading referential integrity in place of triggers?
How do you test your database? : sql server database administration
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is normalization of database?
What is the beast way to write CTE in SQL Server ?