Explaining Explain Plans
Vložit
- čas přidán 8. 07. 2024
- To tune SQL, you need to know how it executed.
To find that out, you need to see the execution plan.
But how to do you make sense of a plan once you've got it?
In this session we'll walk through example plans, discuss common problems, and have your chance to ask questions about understanding SQL performance.
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
asktom.oracle.com/
Oracle Developers portal: developer.oracle.com/
Sign up for an Oracle Cloud trial: cloud.oracle.com/en_US/tryit - Věda a technologie
Thanks for sharing your knowledge
Thanks for sharing this will all - a truly well made and presented video and helpful for all aspiring tuning resources ..
Nice Content. Thanks for the Information
Great Explanation
Hi Christ, you mentioned about an earlier session from 0:29, what video is that? I would like to learn more about it. Much thanks!
Thanks for the information, I have some doubt's
i) can you please expain some time indexes is not pick in excution plan due to which plan get worst
ii) what is difference between hash join and nested join and which join is best
Great video, it really sucks that the audio was very bad
You spent the first 30 min talking about execution plans then say they're very different from explain plans?? The title of the video is "Explaining Explain Plans"... maybe I should've known better but I am a beginner in this stuff so that seemed misleading to me
Not a very useful video, to be honest. Lot of time wasted initially and the important part was rushed.