Advanced Indexing

This page contains the description for my conference session “Advanced Indexing” and links to the slide deck and demo code used in this presentation.


Target audience Beginning and intermediate database developers and DBAs.
Short description An overview of index options beyond the basic clustered and nonclustered indexes.
Duration The ideal length for this session is 60 – 75 minutes.
Full abstract So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you!

You will learn about advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by creating too many indexes.


Click here to download a ZIP file containing the slide deck and demo code used in this presentation.

(Note: my presentations tend to evolve over time, so the slide deck, demo code, and recording linked here may be different from what you saw in a live delivery; and future live deliveries might improve further).

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.