Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 55394 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / rima
NO.If the table has the primary key column, then by default
it will have a clustered index on that primary key
cloumn.So if you want to create a clustered index on non
primary key column then you have to create it before
setting a column as the primary key column or u have to
delete the clustered Primary key columns index to create a
new one.but it is recommended to have a clustered index on
primary key column.
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
Can you explain full-text query in sql server?
What do you know about normalization and de- normalization?
how can a database be repaired? : Sql server administration
Which tools are available to manage SQL Azure databases and servers?
What is the benefit of normalization?
Can you explain powershell included in sql server 2008?
What are window functions in sql server?
What are the types of containers in ssis?
What is the use of group by clause?
what method you can use to reduce the overhead of Reporting Services data sources?
Name and describe few console utilities for ssrs?
What is use of except clause?
How do you troubleshoot errors in a SQL Server Agent Job?
What is RAID? What are the different types of RAID configurations?
Can a database be shrunk to 0 bytes, if not, why?
