Oracle Performance Tuning - Read and interpret Explain Plan

[@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

[@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

[@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]

[@stylishsannigrahi]

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

[@madhavjpn567]

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

[@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.

[@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.

[@manojkumar1585]

very good very Supportive Thank a Lot

[@praveenganesh4708]

Please share the next video link of continuation

[@AmitGupta-kb4ye]

Nicely explained

[@pappubablu9764]

Very nicely explained

[@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

[@farheenmaheen]

excellent work bro. thanq.

[@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

[@ARUNACHALA_SHIVA]

Nice article

[@SatyendraSingh-ul5iq]

Not visible

[@vikramsarguru8852]

Well Explained . Thank You

[@vibhusrivastava]

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

[@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

[@srabantighosh8382]

horrible. too confusing video.. very poor presentation skill

[@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.

[@CrazyFunCricket]

very confused guy

[@AleksandarAleksandar]

It's all wrong.

[@shrutisharma3469]

worst

[@vasanthisiva9362]

not clear