Last week I had the pleasure to present at the aioug Sangam 20 on one of my favorite topics, SQL Tuning.
Often we are lead to believe you need a degree in wizardry to be able to tune sub-optimal SQL statement but in reality, you usually just need to know where to look.
In the session, I look at four different SQL statements that have sub-optimal plans and share details on where I look for information to help me understand why. Once I know the root cause of a problem, it’s easy to apply the appropriate solution.
For those who couldn’t make the session in person, you can download the slides here.