THERE CAN BE AT THE MOST 1 CLUSTERED INDEX FOR ONE TABLE IN SQL SERVER

You may only have one cluster index per table because it
causes the table to be physically re-ordered on the disk. By definition a clustered index physically arranges all data in a table in a sequential manner. Since you can not have more than one physical arrangements of data in a table you can have just one clustered index per table.

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question