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

How do you choose columns to create indexes in a table?

We should create indexes on the columns which are, Mostly used in WHERE clause Mostly used in JOIN conditions Mostly used in Order by If we are creating a concatenated index on more than one column, give first preference to the column

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