Interpreting Oracle Explain Plan Output - John Mullins

Themis Instructor John Mullins presents some details on interpreting Oracle Database Explain Plan output.
For more information visit www.themisinc.com

[@patela21]

full table scans are not always deceptive, considering the query not being optimized properly and hitting large tables multiple times. The explain plan would go for 'direct path read' wait events, so the optimizer will not put the query in the SGA buffer cache instead forces the execution entirely pinning against PGA. This favors the quickest output fetch with a bit downside to the I/O during the query execution.

[@nonamechannel9578]

Super explanation...Very very helpful and informative. To the point, well navigated and no crap..

[@harsimranjitsingh7989]

This is best video i have ever seen on explain plan

[@parakhagarwal7141]

thanks a lot for a really informative video.. Can we have examples of queries which would result in different index access method and join methods ? That would really be helpful

[@performancetesting5227]

Awesome Video. Lots of topics cleared.

[@tirud5782]

Excellent information, very useful for beginners

[@ztech4634]

Very informative and helpful. Great job.

[@mukherjeer]

awesome explanation. thanks man. you rock

[@galeop]

Great stuff!
29:12 are we talking about bitmap *indexes* ?

[@Gbd279]

a valuable follow up video would be to see these considerations being implemented

[@shoaibabdul5428]

very very informative! amazing

[@shashikrishna3481]

Thank you so much!

[@sajitswain]

Thanks a lot. Very useful video.

[@pankajmatani4648]

Very Helpful Video. Thank you sir :)

[@sivaranjani718]

Good explanation !! Thanks !!!

[@kuipersam]

How to investigate this without access to production data? Is there something to 'copy statistics' from production to a test system?

[@himanshuchandra2808]

great video.

[@GeraldoBertoli]

Thanks!!!!!!! Great video.

[@javeed939]

sir how did you decide order of operations

[@user-fi9rw4vx2b]

Cross join isn't a join method. It is a join type (like inner join) and commonly uses merge join method to accomplish

[@vishnuofmillenium]

very well explained

[@satyaprakashpandit1936]

To the point explanation.

[@tusharkumar7424]

Became ur fan

[@diltajchhina]

ੳਰੇਕਲ ਜਿਂਦਾਬਾਦ