Clustered Indexes

SQL Server and Clustered vs. NonClustered Indexes

by SteveStedman
January 9, 2023December 23, 2022
SQL Server

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… Read More »SQL Server and Clustered vs. NonClustered Indexes

Index Overview – Clustered and Nonclustered

by SteveStedman
April 24, 2013April 21, 2013
Performance

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… Read More »Index Overview – Clustered and Nonclustered

Indexing Presentation – The Basics

by SteveStedman
April 27, 2010November 25, 2011
Performance

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… Read More »Indexing Presentation – The Basics