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
How do you delete a trigger?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How to convert a numeric expression from one data type to another?
How to make remote connection in database?
Is oracle faster than sql server?
Data table as parameter in sql server?
Explain how to use linked server?
What is field with example?
Which trace flags are enabled in sql server?
Does partitioning improve performance?
What is difference between rownum and row_number?
What is the difference between DataRow.Delete() and DataRow.Remove()?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is the use of custom fields in report?
What is microsoft sql server?