How many Clustered Indexes we can create on a table? Why?

It is always only one.

Clustered indexes sort and store the values in the physical order. Any table can have only one physical order but not more. Therefore, any table can have maximum of one clustered index always.

Happy Reading  :-) 

Leave a Reply

Your email address will not be published. Required fields are marked *