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

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / amarhindu

8 Answers
21858 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

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

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

Answer / abhijit

Is This Answer Correct ?

5 Yes

1 No

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

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

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

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

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

Answer / samrat sen

yes,you can only create one clustered index on a table.

Is This Answer Correct ?

10 Yes

12 No

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

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

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

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

Post New Answer