Question - Differentiate between ‘Cluster’ and ‘Non-cluster’ index.
Answer -
Clustered index alters the table and re-order the way in which the records are stored in the table. Data retrieval is made faster by using the clustered index.
A Non-clustered index does alter the records that are stored in the table but creates a completely different object within the table.