SQL Tuning Tips You Can’t Do Without

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.

One thought on “SQL Tuning Tips You Can’t Do Without”

Leave a Reply

Your email address will not be published. Required fields are marked *