Last week, I enjoyed presenting at the aioug Sangam 20 on one of my favorite topics, SQL Tuning.
Often, we are led to believe you need a degree in wizardry to tune sub-optimal SQL statement, but in reality, you usually need to know where to look.
In the session, I look at four different SQL statements with 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.
Those who couldn’t make the session in person can download the presentation file from here.