Can we create clustered index on non primary key column
Answer Posted / surya prakash
Finally, i want to conclude by saying.
1. We can create Clustered Index on Non-Primary Key Columns
and this table should not contain any other column with
Primary Key.
2. It is recommended that we create Clustered Indexing on
Primary Key Columns
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
what is unique and xaml nonclustered index
What is the use of RDBMS?
What is the cartesian product of table?
Can we write ddl in trigger?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
How to insert multiple rows with one insert statement in ms sql server?
How to delete database objects with "drop" statements in ms sql server?
How to write a query with an inner join in ms sql server?
What is inline variable assignment?
What are trace flags and mention a few common trace flags used with sql server?
explain different types of joins? : Sql server database administration
what is a mixed extent? : Sql server administration
What is user-defined scalar function?
What is the maximum rows in sql server table?
When would you use sql joins?