Oracle Performance Tuning - Read and interpret Explain Plan

Sdílet
Vložit
  • čas přidán 5. 09. 2024
  • 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
    * CZcams: / itversityin
    #PerformanceTuning #Oracle #Data #itversity
    Join this channel to get access to perks:
    / @itversity

Komentáře • 38

  • @AmitGupta-kb4ye
    @AmitGupta-kb4ye Před 2 lety

    Nicely explained

  • @manojkumar1585
    @manojkumar1585 Před 5 lety +1

    very good very Supportive Thank a Lot

  • @jaspreetsingh9472
    @jaspreetsingh9472 Před 7 lety +4

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

    • @itversity
      @itversity  Před 7 lety +2

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

  • @ARUNACHALA_SHIVA
    @ARUNACHALA_SHIVA Před 2 lety

    Nice article

  • @pappubablu9764
    @pappubablu9764 Před 5 lety

    Very nicely explained

  • @raghavanchellappa6950
    @raghavanchellappa6950 Před 5 lety +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 Před 4 lety

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

  • @stylishsannigrahi
    @stylishsannigrahi Před 5 lety +11

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

  • @popup8249
    @popup8249 Před 5 lety +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

  • @madhavjpn567
    @madhavjpn567 Před 4 lety +2

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

  • @farheenmaheen
    @farheenmaheen Před 8 lety

    excellent work bro. thanq.

  • @praveenamarghade9399
    @praveenamarghade9399 Před 7 lety +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.

  • @vikramsarguru8852
    @vikramsarguru8852 Před 6 lety

    Well Explained . Thank You

  • @shakeelahmed8624
    @shakeelahmed8624 Před 7 lety

    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
    @azurtle Před 4 lety

    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
    @praveenganesh4708 Před 5 lety

    Please share the next video link of continuation

  • @SatyendraSingh-ul5iq
    @SatyendraSingh-ul5iq Před 3 lety

    Not visible

  • @vasanthisiva9362
    @vasanthisiva9362 Před rokem

    not clear

  • @vibhusrivastava
    @vibhusrivastava Před 7 lety +4

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

  • @itversity
    @itversity  Před 7 lety

    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 Před 3 lety

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

    • @gannonjamir7964
      @gannonjamir7964 Před 3 lety

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

    • @jaseharold3119
      @jaseharold3119 Před 3 lety

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

    • @jacobjamari4578
      @jacobjamari4578 Před 3 lety

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

    • @gannonjamir7964
      @gannonjamir7964 Před 3 lety

      @Jacob Jamari you are welcome xD

  • @gshiva1084
    @gshiva1084 Před 6 lety +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

  • @sanjayanayak6331
    @sanjayanayak6331 Před 7 lety +4

    Presentation was not good.

    • @itversity
      @itversity  Před 7 lety +1

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

    • @rahulmishra4111
      @rahulmishra4111 Před 7 lety

      Diagram should be more clear.

    • @shekhar0507
      @shekhar0507 Před 5 lety

      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
    @srabantighosh8382 Před 6 lety +1

    horrible. too confusing video.. very poor presentation skill

  • @CrazyFunCricket
    @CrazyFunCricket Před 3 lety

    very confused guy

  • @AleksandarAleksandar
    @AleksandarAleksandar Před rokem

    It's all wrong.

  • @shrutisharma3469
    @shrutisharma3469 Před 3 lety

    worst

  • @sdonram
    @sdonram Před 2 lety

    Not clear