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.
Keep the good work please.
Regards
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.