Can we create clustered index on non primary key column
- 20 Answers
- 51428 Views
- ABC, CTS, I also Faced
- E-Mail Answers
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 a deadlock and what is a live lock?
What is the cartesian product of the table?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is check constraint in sql server?
Explain unique key in sql server?
What command do we use to rename a db, a table and a column?
Explain about Normalization?
Explain multiserver query
What is 3nf normalization form?
What is the purpose of linked server configuration in sql server?
What is the Difference Between Primary and Foreign Key?
How to create stored procedures with parameters in ms sql server?
What is the difference between Normalization and De-normalization?
Can we write ddl in trigger?
