I have recently been doing presentations about SQL tuning, but haven’t really written anything on the topic here. Therefore, I have decided to put together a series of posts over the next few weeks on the process I use for tuning SQL. I plan to cover:
– Viewing and interpreting the current execution plan for a query
– Using a visual approach to find an optimal execution plan
– Various methods that can be used to go from the current execution plan to the optimal one
– Review of some tools that can help with these tasks