Explaining Explain Plans

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

[@sumeetsingh695]

Thanks for sharing this will all - a truly well made and presented video and helpful for all aspiring tuning resources ..

[@fernandofrancisc]

Thanks for sharing your knowledge

[@manojremala]

Nice Content. Thanks for the Information

[@AmitGupta-kb4ye]

Great Explanation

[@mohamedyamani8502]

Great video, it really sucks that the audio was very bad

[@sameerkhan-oy4lz]

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

[@babambigolo7869]

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!

[@joespinelli3604]

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

[@vdiitd]

Not a very useful video, to be honest. Lot of time wasted initially and the important part was rushed.