SQL Tuning Tips You Can’t Do Without

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.

3 thoughts on “SQL Tuning Tips You Can’t Do Without”

  1. At the very end:

    2: Look at how the SQL statement is written and how the predicates are being use

    should probably be

    2: Look at how the SQL statement is written and how the predicates are being used

    I was going to send you a DM on twitter about this, but I guess I have yet to get the follow (@richsoule). 😉

Leave a Reply

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