Oracle Performance Tuning - Read and interpret Explain Plan

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 38

  • @popup8249
    @popup8249 5 років тому +10

    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

  • @stylishsannigrahi
    @stylishsannigrahi 6 років тому +10

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

  • @raghavanchellappa6950
    @raghavanchellappa6950 5 років тому +8

    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
      @madhavjpn567 4 роки тому

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

  • @jaspreetsingh9472
    @jaspreetsingh9472 7 років тому +4

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

    • @itversity
      @itversity  7 років тому +2

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

  • @AmitGupta-kb4ye
    @AmitGupta-kb4ye 2 роки тому

    Nicely explained

  • @madhavjpn567
    @madhavjpn567 4 роки тому +2

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

  • @ARUNACHALA_SHIVA
    @ARUNACHALA_SHIVA 2 роки тому

    Nice article

  • @praveenamarghade9399
    @praveenamarghade9399 7 років тому +10

    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.

  • @pappubablu9764
    @pappubablu9764 5 років тому

    Very nicely explained

  • @manojkumar1585
    @manojkumar1585 6 років тому +1

    very good very Supportive Thank a Lot

  • @shakeelahmed8624
    @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

  • @praveenganesh4708
    @praveenganesh4708 6 років тому

    Please share the next video link of continuation

  • @farheenmaheen
    @farheenmaheen 8 років тому

    excellent work bro. thanq.

  • @azurtle
    @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

  • @vikramsarguru8852
    @vikramsarguru8852 6 років тому

    Well Explained . Thank You

  • @SatyendraSingh-ul5iq
    @SatyendraSingh-ul5iq 3 роки тому

    Not visible

  • @vibhusrivastava
    @vibhusrivastava 7 років тому +4

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

  • @itversity
    @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
      @jacobjamari4578 3 роки тому

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

    • @gannonjamir7964
      @gannonjamir7964 3 роки тому

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

    • @jaseharold3119
      @jaseharold3119 3 роки тому

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

    • @jacobjamari4578
      @jacobjamari4578 3 роки тому

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

    • @gannonjamir7964
      @gannonjamir7964 3 роки тому

      @Jacob Jamari you are welcome xD

  • @sdonram
    @sdonram 2 роки тому

    Not clear

  • @gshiva1084
    @gshiva1084 6 років тому +3

    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
    @srabantighosh8382 6 років тому +1

    horrible. too confusing video.. very poor presentation skill

  • @sanjayanayak6331
    @sanjayanayak6331 7 років тому +4

    Presentation was not good.

    • @itversity
      @itversity  7 років тому +1

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

    • @rahulmishra4111
      @rahulmishra4111 7 років тому

      Diagram should be more clear.

    • @shekhar0507
      @shekhar0507 6 років тому

      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
    @CrazyFunCricket 3 роки тому

    very confused guy

  • @AleksandarAleksandar
    @AleksandarAleksandar 2 роки тому

    It's all wrong.

  • @shrutisharma3469
    @shrutisharma3469 3 роки тому

    worst

  • @vasanthisiva9362
    @vasanthisiva9362 Рік тому

    not clear