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?