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   

Read More

What is the difference between Clustered index & Non Clustered Index?

Clustered Index Data is stored in physical order. The leaf nodes of Clustered indexes will contain actual data. Only one clustered index should exist in a table.  Non-Clustered Index It does not sort the data in physical order. But it will have

Read More