Index Overview – Clustered and Nonclustered
This is intended as a brief overview of indexing on SQL Server. Understanding and using indexes can lead to some major performance improvements. Non-Clustered Indexes Non-Clustered indexes are often times considered traditional indexing – contains pointers to the data. This …