top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Why a table can have only single clustered index ?

+2 votes
255 views
Why a table can have only single clustered index ?
posted Jan 19, 2014 by Atul Mishra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

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.

answer Jan 26, 2014 by Neeraj Pandey
Similar Questions
+4 votes

My table is too big and now i realize that i need to add few columns in that, but when i tried to do this, my alter script took more then 4 hours and database performance also got degraded, so i canceled the query, can anyone suggest better way of doing that

...