The five-step guide to SQL tuning | CloudWorld 2022

Find out more: social.ora.cl/60005XvQK
It's the age-old problem, and one of the most common questions posted on AskTom. What to do when a SQL statement-one that needs to run in 5 milliseconds-instead runs in 5 seconds, 5 minutes, or 5 hours? We start from this point in the process and show you the approach to take when investigating and resolving SQL performance problems. We cover various usage modes of DBMS_XPLAN to assess SQL performance, how to detect if an execution plan is the best plan, and quick tricks to buy you time while you focus on a permanent solution.
Watch Connor McDonald, developer advocate for SQL at Oracle, outline the five-step guide to SQL tuning at CloudWorld 2022.
Like what you learned about SQL tuning? Subscribe now social.ora.cl/60063aboY
Contact Database Sales: social.ora.cl/6004zuD5G
Join us at Oracle CloudWorld - social.ora.cl/6007PuGg5
Oracle Database Events - social.ora.cl/6008Pnz6j
Oracle Database Cloud - social.ora.cl/6004PnzDj
Oracle Database 21c - social.ora.cl/6000Pnz1I
Oracle MySQL - social.ora.cl/6001PnzyN
Oracle Autonomous Database - social.ora.cl/6004PnzMp
What is a Database? - social.ora.cl/6003PnzPD
What is a Data Warehouse? - social.ora.cl/6004Pnzug
Follow us here:
LinkedIn: social.ora.cl/60013ab3t
Facebook: social.ora.cl/60003abOn
Instagram: social.ora.cl/60083abPj
Twitter: social.ora.cl/60003abur
#sql #cloudworld2022 #developer

[@marcinbadtke]

Thank you. Much needed and often forgotten perspective.

[@tomaslozada9397]

Excellent explanation. The video is also very well put together

[@abhijitmane9949]

Long but very knowledgeable. Thanks :)

[@yarik2303]

wow, I always thought I knew everything about this, but this wonderful video revealed a lot more to me

[@ainguyenkha4811]

VERRYYY EXELENT PRESENTATION , TKSS A LOTTT

[@pedrokarandeniya162]

👏