The five-step guide to SQL tuning CloudWorld 2022

Channel Avatar
Comment
X
Share
The five-step guide to SQL tuning CloudWorld 2022
The five-step guide to SQL tuning CloudWorld 2022
Find out more: https://social.ora.cl/6003PnOmc
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 https://social.ora.cl/60063aboY

Contact Database Sales: https://social.ora.cl/6004zuD5G
Join us at Oracle CloudWorld – https://social.ora.cl/6007PuGg5
Oracle Database Events – https://social.ora.cl/6008Pnz6j
Oracle Database Cloud – https://social.ora.cl/6004PnzDj
Oracle Database 21c – https://social.ora.cl/6000Pnz1I
Oracle MySQL – https://social.ora.cl/6001PnzyN
Oracle Autonomous Database – https://social.ora.cl/6004PnzMp
What is a Database? – https://social.ora.cl/6003PnzPD
What is a Data Warehouse? – https://social.ora.cl/6004Pnzug

Follow us here:
LinkedIn: https://social.ora.cl/60013ab3t
Facebook: https://social.ora.cl/60003abOn
Instagram: https://social.ora.cl/60083abPj
Twitter: https://social.ora.cl/60003abur

#sql #cloudworld2022 #developer

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

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