What is there difference between clustered index and non-clustered index?
Important difference between these is, Clustered index consists of table data at leaf nodes, where as Non-Clustered index consists of pointer to the table row.
Another difference is regarding allowed indexes count, there will be only 1 CI per table. We can have upto 255 Non-CI until SQL Server 2005, From SQL Server 2008, limit increased to 999.
SQL Server Interview Questions · · · ·