22-25 April 2026 
Stop Indexing the Query! Table Tuning Part II
Proposed session for SQLBits 2026TL; DR
Learn how to turn insights into actionable optimisations and become the awesome hero you were meant to be.
Session Details
Don't worry if you missed Part I - I will be providing a recap of how we got here so that we can pick up with the next extension of Table Tuning Part II. We will explore indexing strategies we've seen in the wild, the purpose of this discussion which is to make you awesome, Table Tuning methodology, queries to do your own digging, XMLNAMESPACES parsing!, proper prioritization of our efforts, and a demo! Then, go off with even more awesomeness.
3 things you'll get out of this session
Learn the methods of table tuning and how to put insights into practical use.
Speakers
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.