In SQL Server, an index is a data structure that allows you to quickly retrieve data from a table based on the values of one or more columns. There are two main types of indexes in SQL Server: clustered and nonclustered indexes. A clustered index A nonclustered index The main difference between a clustered and a nonclustered index is how …

SQL Server and Clustered vs. NonClustered Indexes Read more »

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 is similar to the index at the back of a book. If you open a book to the index, then …

Index Overview – Clustered and Nonclustered Read more »

Attached is the slide deck for a short presentation on indexing that was created to educate software developers on the basics of indexing. Outline: What is an Index Types of Indexes Non Clustered Indexes Clustered Indexes When To Avoid A Clustered Index Covered Indexes Index Usage Terminology Summary Additional Topics Download Indexing_Overview.pdf Here is the text outline of the presentation.   …

Indexing Presentation – The Basics Read more »