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”
Keep the good work please.
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). 😉
Thanks, Richard! I’ve corrected the error.