The five-step guide to SQL tuning | CloudWorld 2022

preview_player
Показать описание

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.

Follow us here:

#sql #cloudworld2022 #developer
Рекомендации по теме
Комментарии
Автор

Excellent explanation. The video is also very well put together

tomaslozada
Автор

Thank you. Much needed and often forgotten perspective.

marcinbadtke
Автор

Long but very knowledgeable. Thanks :)

abhijitmane
Автор

indeed, parallel is the 1st thing which comes to mind :D

vikram
Автор

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

yarik
Автор

VERRYYY EXELENT PRESENTATION, TKSS A LOTTT <3

ainguyenkha