WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?

Answer Posted / jai

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete a trigger?

742


Where sql server user names and passwords are stored in sql server? : sql server database administration

795


How to convert a numeric expression from one data type to another?

697


How to make remote connection in database?

752


Is oracle faster than sql server?

713






Data table as parameter in sql server?

721


Explain how to use linked server?

741


What is field with example?

681


Which trace flags are enabled in sql server?

675


Does partitioning improve performance?

716


What is difference between rownum and row_number?

695


What is the difference between DataRow.Delete() and DataRow.Remove()?

948


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

731


What is the use of custom fields in report?

762


What is microsoft sql server?

696