SQLBits 2023

Stop Indexing the Query

Find out how to index for YOUR workload instead of adding an index for a problem query. I'll share my methodology with you to make you a better optimizer.

If you are like me, when doing tuning and optimization efforts, you tend to find a long running query or a query consuming a lot of resources in the form or logical reads. We dig into these queries and many times, we find that it could benefit from an index or adjusting an existing index. So, we do that. However, what did we just do to the overall workload? Was it good, bad, or indifferent?

Rob Mandeville's other proposed sessions for 2026

Stop Indexing the Query! Table Tuning Part II - 2026

Rob Mandeville's previous sessions

Stop Indexing the Query

Find out how to index for YOUR workload instead of adding an index for a problem query. I'll share my methodology with you to make you a better optimizer.

Should We Defragment Indexes?

You may want to stop or limit defragmenting your indexes when you encounter external fragmentation because it may be causing performance degradation. Join us as we take a deeper look at modern disk architecture and what's actually happening with I/O.