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
List the different normalization forms?
How to generate create view script on an existing view?
Explain the steps to use transact-sql cursor?
Write a SQL query to make a column as unique?
Explain user defined views?
What is format parameter in ssrs?
What are various aggregate functions that are available?
Does windows server 2016 come with sql server?
what information is maintained within the msdb database? : Sql server administration
When you should use a low fill factor?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Can we write ddl in trigger?
What does the on delete cascade option do?
What is an entity-relationship diagram (erd)?
Explain about nested stored procedure?