What Is The Difference Between Clustered And Non-clustered Indexes?
Answer»
One table can have only one clustered index but multiple NONCLUSTERED indexes.
Clustered indexes can be READRAPIDLY rather than non-clustered indexes.
Clustered indexes store data PHYSICALLY in the table or view and non-clustered indexes do not store data in table as it has separate STRUCTURE from data row