An approach to index tuning – Part 2
SQL Performance
APRIL 13, 2020
In my last post , I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one. This is where index tuning becomes an art. Then I roll through and force each index with a hint, capturing the plan and performance metrics for each execution.
Let's personalize your content