WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answers were Sorted based on User's Feedback
Answer / honnur swamy
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 ? | 33 Yes | 3 No |
Answer / samrat sen
Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.
Is This Answer Correct ? | 14 Yes | 10 No |
Answer / abhijit
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 ? | 5 Yes | 1 No |
Answer / shailesh arban
Because cluster index sort data in table based on key value that is you primary key value and primary key values are unique in table therefore cluster index only one on table.
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / 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 |
Answer / samrat sen
yes,you can only create one clustered index on a table.
Is This Answer Correct ? | 10 Yes | 12 No |
Answer / muthu
Clustered index based on Primary Key. So if we create a PK,
automatically Clustered Index will be created. So only one
CI available for a table.
Is This Answer Correct ? | 10 Yes | 14 No |
Answer / raju.r
we can create ony ONE clustered index per table .. for Non-
clusrtered index we can create 249 ...
Is This Answer Correct ? | 4 Yes | 11 No |
What do you mean by acid?
How to transfer data from a cursor to variables with a "fetch" statement?
Explain what is the difference between union and union all?
What are entities and relationships?
In which situation you use Self joins?
1 Answers CarrizalSoft Technologies, HP, TCS,
what's the information that can be stored inside a bit column? : Sql server database administration
What is subquery in sql?
What is scrollable cursor?
How to define the name and server for a new dsn?
What is tempdb in sql server?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
What is replace and stuff function in sql server?