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  :-) 

Latest Comments
  1. Saikrishna Papareddy


Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.