Oracle Performance Tuning - Read and interpret Explain Plan

For quick itversity updates, subscribe to our newsletter or follow us on social platforms.
* Newsletter: notifyme.itvers...
* LinkedIn: / itversity
* Facebook: / itversity
* Twitter: / itversity
* Instagram: / itversity
* KZbin: / itversityin
#PerformanceTuning #Oracle #Data #itversity
Join this channel to get access to perks:
/ @itversity

[@stylishsannigrahi]

This is actually confusing and incorrect in many ways because of clumsy presentation .

[@popup8249]

Please explain in right way ... don’t misroute others with you half knowledge on interpretation of explain plan You should be in a position to explain how the branches should be divided , on what basis we have to divide

[@AmitGupta-kb4ye]

Nicely explained

[@manojkumar1585]

very good very Supportive Thank a Lot

[@raghavanchellappa6950]

I am sorry, Its completely wrong and how are you trying to read the explain plan from the beginning. It should be bottom up approach. My expectation was, you give explanation why Nested loop is obtained rather than Merge sort and Hash.

[@madhavjpn567]

Raghav, can you send the right approach video in interpreting explain plan....to [e-mail]

[@ARUNACHALA_SHIVA]

Nice article

[@pappubablu9764]

Very nicely explained

[@jaspreetsingh9472]

Sir your Concepts are good kindly pay attention in presenting it well ...

[@itversity]

Thank you for the feedback. I will keep that in mind when I start creating content for Oracle in near future.

[@madhavjpn567]

nice but the representation was bit not clear...can you provide details of how the same query perfornance can be improved

[@farheenmaheen]

excellent work bro. thanq.

[@praveenamarghade9399]

Sir, u have good understanding of concepts but requesting to try to improve your presentation skills. Here you messed up things together. But thank u for your efforts.

[@vikramsarguru8852]

Well Explained . Thank You

[@shakeelahmed8624]

I appreciate your efforts you made for us, can you please tell me the first tool is sql developer but the query you copied from sql developer, where did you pasted where you worked all, showed the steps, I am actually unable to see that white screen where everything can be seen. Thanks

[@azurtle]

Aren't you supposed to start at the right most indent ..... the way you do your tree branches, I don't think is correct....correct me if i'm wrong. I also came here to understand how to read the explain plan, like what cost means and how it was generated....not about b-trees only

[@praveenganesh4708]

Please share the next video link of continuation

[@SatyendraSingh-ul5iq]

Not visible

[@vibhusrivastava]

sir way of presenting is not well......context is good....

[@vasanthisiva9362]

not clear

[@sdonram]

Not clear

[@gshiva1084]

I ma not understand any thing what u explained and while I am watching your video getting mad so kindly requesting improve your presentation skills and explain clearly

[@itversity]

For any technical discussions or doubts, please use our forum - discuss.itversity.com For practicing on state of the art big data cluster, please sign up on - labs.itversity.com Lab is under free preview until 12/31/2016 and after that subscription charges are 14.99$ per 31 days, 34.99$ per 93 days and 54.99$ per 185 days

[@jacobjamari4578]

i know I am kinda randomly asking but does anybody know a good website to stream newly released tv shows online?

[@gannonjamir7964]

@Jacob Jamari i watch on FlixZone. You can find it on google :)

[@jaseharold3119]

@Gannon Jamir Yup, I've been using flixzone for years myself =)

[@jacobjamari4578]

@Gannon Jamir Thanks, I went there and it seems like they got a lot of movies there :D I appreciate it!!

[@gannonjamir7964]

@Jacob Jamari you are welcome xD

[@sanjayanayak6331]

Presentation was not good.

[@itversity]

We will thrive to get better at it. It will be better if you can throw light on what is lacking.

[@rahulmishra4111]

Diagram should be more clear.

[@shekhar0507]

Could had used power point presentation rather than white boarding. The whole image became very dirty. Also should use pause for video when u r thinking something or some command are not working. Content is good but presentation is not well prepared.

[@srabantighosh8382]

horrible. too confusing video.. very poor presentation skill

[@CrazyFunCricket]

very confused guy

[@AleksandarAleksandar]

It's all wrong.

[@shrutisharma3469]

worst