Oracle Performance Tuning - EXPLAIN PLAN

An overview of EXPLAIN PLAN feature of Oracle with demo on how to generate the plan and interpret the plan.

[aakashteotia]

Excellent video. Just one video and I get an excellent overview of explain plan. Gonna watch other continuation videos as well.

[nareshtamiri]

Very good explanation please upload more videos related to performance tuning

[BewithuNnk]

Tq for upload. How to trace if it's a query getting slow with an explain plan and what are the steps to solveif find something

[madhubabu]

Thank you for video , I have a query with view, that view made on joining two views ...select *from v1 where sno=123 like this taking too much time how to analysis query and how to improve that query performance

[sandhyavijay]

what is Hash Join in the given example?

[gautamtrivedi]

Good practical session please share a more practical video on performance tunning.

[rakeshs]

Very good explanation Saurabh.. I am waiting for Access Methods video.:)

[parmeshwarhippargi]

Please do create video on join method used in explain plan and access methods. Thanks

[sandeepgautam]

Thank you Saurabh...very helpful for me.

[ashishchamoli]

Hi, this video is helpful for beginners. Will you be able to add a video mentioning how to read big explain plan for complex query.

I mean from where to start reading explain plan and go on.

Thank you

[vipul]

Nice video... I came here from PL/SQL Developer Channel in Telegram... Will be looking forward for your more videos for in-depth analysis of the explain plan and please make more on Tuning as well....Keep up the great work and your explanation is really easy to

[shashank]

Nice video, but can u explains more about the use of bytes and cost how it's calculated and how to tune the query?

[piyushnikhade]

One question I need to ask that explain plan is used for select clause based queries only ?

[marianfernandes]

In which scenario do we face “TABLE ACCESS BY ROWID”

[Philomathic_human]

Can you explain plan hash value? What is the purpose and how it works?

[rajatchhabra]

I am wondering what's the print on your T-Shirt seems odd as it doesn't give the full picture and may confuse people in the video ... I hope its Cup Cakes with Cherry Toppings... lol

[mohantadibyajyoti]

Please create video on statistics for analyzing issue

[dipakit]

SIR, GIVE ME INTERVIEW PERSPECTIVE, HOW WILL YOU GIVING ANSWER TO INTERVIEWRS.

[Alokkumar-mepl]

bro, ur voice modulation is similar to Roman Saini (Unacademy cofounder)..🤗 btw nice explanatiom.. can u just make Part2 of it

[venkatv]

Upload more videos on performance tuning like wait events and different type of locks..