Oracle Performance Tuning - Read and interpret Explain Plan

Подписаться 67 тыс.

Просмотров 106 тыс.

50% 1

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

Наука

Опубликовано:

13 ноя 2015

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 38

@stylishsannigrahi 5 лет назад

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

@shakeelahmed8624 7 лет назад

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

@popup8249 5 лет назад

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

@farheenmaheen 8 лет назад

excellent work bro. thanq.

@manojkumar1585 5 лет назад

very good very Supportive Thank a Lot

@pappubablu9764 4 года назад

Very nicely explained

@madhavjpn567 4 года назад

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

@AmitGupta-kb4ye 2 года назад

Nicely explained

@praveenganesh4708 5 лет назад

Please share the next video link of continuation

@ARUNACHALA_SHIVA 2 года назад

Nice article

@vikramsarguru8852 6 лет назад

Well Explained . Thank You

@raghavanchellappa6950 5 лет назад

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 4 года назад

Raghav, can you send the right approach video in interpreting explain plan....to madhavjpn567@gmail.com

@jaspreetsingh9472 7 лет назад

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

@itversity 7 лет назад

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

@azurtle 4 года назад

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

@praveenamarghade9399 7 лет назад

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.

@itversity 7 лет назад

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 3 года назад

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

@gannonjamir7964 3 года назад

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

@jaseharold3119 3 года назад

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

@jacobjamari4578 3 года назад

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

@gannonjamir7964 3 года назад

@Jacob Jamari you are welcome xD

@SatyendraSingh-ul5iq 3 года назад

Not visible

@vibhusrivastava 7 лет назад

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

@sdonram 2 года назад

Not clear

@vasanthisiva9362 Год назад

not clear

@gshiva1084 6 лет назад

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

@sanjayanayak6331 7 лет назад

Presentation was not good.

@itversity 7 лет назад

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

@rahulmishra4111 7 лет назад

Diagram should be more clear.

@shekhar0507 5 лет назад

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.