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 difference between rollback immediate and with no_wait during alter database?
How to add additional conditions in SQL?
What are the new data types are introduced in sql 2000?
How do we synchronize On-Premise SQL server with SQL Azure?
What is row_number()?
What is difference between getdate and sysdatetime in sql server 2008?
What is optimization and its types?
What are the different acid properties?
Can a trigger be created on a view?
How to create new databases with "create database" statements?
How to delete duplicate rows?
Define left outer join?
how you can move data or databases between servers and databases in sql server? : Sql server administration
Why I have to use stored procedures?
What is the sql case statement used for?