Indexing in Oracle :B-Tree,Bitmap Indexing

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ธ.ค. 2024
  • This Video is the 1st tutorial in the video series Indexing in Oracle , The video series explains in detail, What are indexes?It's types, what index should be used in which scenario and other important thing in basic terminology.
    Note :You may want to watch the video with a higher playback speed(1.25 if it suits you more)
    #OracleIndexing #BTreeIndex #Techcoach

ความคิดเห็น • 137

  • @harshiniborra4933
    @harshiniborra4933 ปีที่แล้ว

    This is the one I found...The most decomplexified explanation of a complex topic..Thanks a million.👏

  • @rohitagrawal2451
    @rohitagrawal2451 6 ปีที่แล้ว +2

    After whole lot of search, One of best tutorial i found on Index .

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks a lot Rohit for the kind words.
      I need a small help I am working on this new youtube channel and would really appreciate if you watch and subscribe to it.
      th-cam.com/video/HBQHekM1U2c/w-d-xo.html

  • @Shashwatoctober
    @Shashwatoctober ปีที่แล้ว

    this information we can not get anywhere else. Such in-depth exlanation. Loved it. Going to binge watch the complete playlist and flaunt my knowledge

  • @PujanShah-o3b
    @PujanShah-o3b ปีที่แล้ว

    very nice explanation. It not only clears the concept but also make your optimisation skills more powerful.

  • @prasadzagde8210
    @prasadzagde8210 2 ปีที่แล้ว +1

    Very nicely explained.. Volume and Speed is also very clear and comfortable..Thanks a lot.

  • @akashkumarmahato-kv1iz
    @akashkumarmahato-kv1iz ปีที่แล้ว

    simply no words. excellent explanation.

  • @ztech4634
    @ztech4634 3 ปีที่แล้ว

    I agree with Dupati, this is the best video on Index that I have come across! great work.

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      Thanks a lot for the kind words :)

  • @bhartendukumar5168
    @bhartendukumar5168 ปีที่แล้ว

    Super se v upar ....,.thanks alot

  • @uzzalbasak2517
    @uzzalbasak2517 2 ปีที่แล้ว +1

    Very Clear concept regarding invisible and unusable Index. :)

    • @TechCoach
      @TechCoach  2 ปีที่แล้ว

      Thanks buddy , I am glad I could help:)

  • @Crazy4DB
    @Crazy4DB 5 ปีที่แล้ว +7

    I suggest put the links of related videos in this series in description box for to be able to find easily

  • @rohitchoubey1809
    @rohitchoubey1809 5 ปีที่แล้ว +2

    Awesome lecture, everything is crystal clear now, thanks again for such an awesome lecture

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      Thanks Rohit for the kind words,I have a small request
      I am working on this new youtube channel, I Would love it if you watch and subscribe to it as well.
      Please share with ur friends also.
      th-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

  • @GauravKumar-ec8vd
    @GauravKumar-ec8vd 6 ปีที่แล้ว +1

    This tutorial is to-the-point. Great job done, sir. Thank you so much.

    • @AnIndianAbroadd
      @AnIndianAbroadd 6 ปีที่แล้ว

      Thanks for the kind words Gaurav.
      I have a small request, I am working on this new channel " An Indian Abroad" and will really appreciate if you watch and subscribe to it.
      th-cam.com/video/cvH4oEX3wx8/w-d-xo.html

  • @higurashinilsson1477
    @higurashinilsson1477 2 ปีที่แล้ว

    Very good and clear. Thank you!

  • @dupatisaimanoj5626
    @dupatisaimanoj5626 6 ปีที่แล้ว

    Best video on index still now I haven't seen like this

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      +dupati sai manoj Thanks for the kind words

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Please help me in my new Initiative by subscribing sharing and watching my new youtube channel
      "An Indian Abroad"
      th-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

  • @jawaharthangaraj9185
    @jawaharthangaraj9185 3 ปีที่แล้ว

    Good explanation about indexes with the details of Balanced Search Tree, keep it up.

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      Thanks Buddy for the kind words.
      Please consider subscribing to my other channel as well. It will really help me.
      th-cam.com/video/6G1xGi-D5ow/w-d-xo.html

  • @therealjordiano
    @therealjordiano ปีที่แล้ว

    lovely tutorial bruh thanks

  • @keertisurana8765
    @keertisurana8765 6 ปีที่แล้ว +1

    Thanks Vivek. Very nice explanation on Indexing. Very easy to understand. Thanks again.

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks a lot for the kind words.
      I would really appreciate if you help me in my new Initiative "An Indian Abroad"
      by subscribing viewing and sharing.
      th-cam.com/users/AnIndianAbroadd

  • @andrewmarcus5173
    @andrewmarcus5173 5 หลายเดือนก่อน

    thank you so much. very nice video

  • @xxNguyenTungxx
    @xxNguyenTungxx 2 ปีที่แล้ว

    Thanks for nice shared

  • @dipanjanmukherjee4338
    @dipanjanmukherjee4338 4 ปีที่แล้ว

    Superb explanation !!

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Glad it was helpful! Dipanjan :)

  • @rohithgorthy971
    @rohithgorthy971 4 ปีที่แล้ว +2

    It was extremely neat, Very clearly explained in layman terms. Appreciate your efforts. Can you please help us with a use case of B tree index & Bit map index. Thank you.

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Hi Rohith, thanks for the kind words.
      There are 7 videos in Indexing playlist.
      They may answer some of your questions :)
      th-cam.com/play/PLUWdEQb_2yqVXnx-P1881VVtec8moW1sk.html

  • @HaraprasadSwain
    @HaraprasadSwain 4 ปีที่แล้ว

    Pretty crystal. Keep up the good work man.

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks HaraPrasad for the kind words :)

  • @Eira.2010
    @Eira.2010 3 ปีที่แล้ว

    Very nicely explained ..

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      Thanks Basanti for the kind words.
      Please consider subscribing to my other channel as well. It will really help me.
      th-cam.com/video/6G1xGi-D5ow/w-d-xo.html

  • @anoopakk1562
    @anoopakk1562 3 ปีที่แล้ว +1

    Good tutorial

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      Thanks Buddy :)

  • @mmanukumar6194
    @mmanukumar6194 ปีที่แล้ว

    Hi @Tech coach,
    Cab we create B tree indexes in partitioned table?

  • @tanbhatt3493
    @tanbhatt3493 6 ปีที่แล้ว +1

    awesome, Thanks for this video

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks Tan for the kind words.
      I have a small request, I am working on this new youtube channel "An Indian abroad".
      It will really help me if you watch and subscribe to it.
      th-cam.com/video/HBQHekM1U2c/w-d-xo.html

  • @amitkumar-ev8im
    @amitkumar-ev8im 6 ปีที่แล้ว

    Really very nice tutorial.Thanks lot for your help.

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks amit for the kind words and my apologies for the delayed reply.

  • @hakhandare
    @hakhandare 4 ปีที่แล้ว

    Thanks for sharing valuable knowledge

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks Hemant for the kind words :) , I will recommend watching the entire indexing series :)

  • @kushagrasrivastava8551
    @kushagrasrivastava8551 3 ปีที่แล้ว +1

    can you let me know the sql related questions for an experienced professional which are asked in a delloite interview for data analyst

  • @sivaveeramallu3645
    @sivaveeramallu3645 5 ปีที่แล้ว

    Excellent Explaination

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      Thanks a lot for the kind words bobby :)

  • @DepMahesh
    @DepMahesh 6 ปีที่แล้ว +1

    Nice explanation, thanks...👍

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks a lot Dep Mahesh for the kind words.
      I need a small help I am working on this new youtube channel and would really appreciate if you watch and subscribe to it.
      th-cam.com/video/11DK-oyRql0/w-d-xo.html

  • @dpranow8450
    @dpranow8450 4 ปีที่แล้ว

    Great job!!! Tq lot

  • @abhijitmane9949
    @abhijitmane9949 ปีที่แล้ว

    In Unusable index if actual index is dropped from physical memory then what we are rebuilding? Or it's just index for new data will be dropped?

  • @hemanthdev8882
    @hemanthdev8882 5 ปีที่แล้ว

    Topic well explained , great going Vivek!!

  • @durgaprasadsriramoji5111
    @durgaprasadsriramoji5111 4 ปีที่แล้ว +1

    what do u mean by index clean up? how does drop index differ from making it UNUSED

  • @shrutisinghal8556
    @shrutisinghal8556 6 ปีที่แล้ว +1

    Nice video. Thanks Vivek. I am happy that I somehow reached your channel!!

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks a lot shruti for the kind words :)

  • @yashwanth990
    @yashwanth990 6 ปีที่แล้ว

    Superb explanation sir...

    • @AnIndianAbroadd
      @AnIndianAbroadd 6 ปีที่แล้ว

      Thanks a lot for the kind words, I have a small request I am working on this new youtube channel " An Indian Abroad " and will really appreciate if you watch and subscribe to it.
      th-cam.com/video/11DK-oyRql0/w-d-xo.html

    • @AnIndianAbroadd
      @AnIndianAbroadd 6 ปีที่แล้ว

      Thanks a lot for the kind words, I have a small request I am working on this new youtube channel " An Indian Abroad " and will really appreciate if you watch and subscribe to it.
      th-cam.com/video/11DK-oyRql0/w-d-xo.html

  • @kirandalvi3406
    @kirandalvi3406 6 ปีที่แล้ว +1

    Please make video on Index oraganized table also on performance tunning in explain plan, what is awr report, and processor utilization..please make video on this topic

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Sure Kiran I will work on it.

  • @ankushgondane8642
    @ankushgondane8642 6 ปีที่แล้ว

    This video has great information. Thanks Vivek. Keep it up👍

  • @kirannikam4695
    @kirannikam4695 6 ปีที่แล้ว

    mast yaar... thanks

    • @AnIndianAbroadd
      @AnIndianAbroadd 6 ปีที่แล้ว

      Thanks Kiran.I have a small request, I am working on a new channel " An Indian Abroad" and it will really help me if you watch and subscribe to it.
      th-cam.com/video/QrpPc-WNjoU/w-d-xo.html

  • @vishalsaxena5081
    @vishalsaxena5081 3 ปีที่แล้ว

    please explain non cluster index

  • @pavanyadav999
    @pavanyadav999 6 ปีที่แล้ว +1

    Thank You for your video.. :)

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks for the wonderful comment, I have a small request I am working on this new youtube channel
      "An Indian Abroad"
      It will really help me if you watch and subscribe to it.
      th-cam.com/video/HBQHekM1U2c/w-d-xo.html

  • @varunagnihotri4812
    @varunagnihotri4812 4 ปีที่แล้ว

    Hi, nice explanation. Can you tell me the resources to learn query optimization for a developer or an analyst. I found some books but either they are too complex to understand or too big to digest.
    Thanks.

  • @pranjalsharma3765
    @pranjalsharma3765 6 ปีที่แล้ว +1

    Thanks a lot ,ur video helped me a lot but where is domain index, descending index and key compression index. These topics are in the content but couldn't find in any of ur index videos.

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Hi Pranjal, Thanks for the kind words.
      Some videos are pending for Index series I am working on them.
      I have a small request I am working on this new channel.
      "An Indian Abroad" I will really appreciate if you watch and subscribe to it.
      th-cam.com/video/HBQHekM1U2c/w-d-xo.html

    • @pranjalsharma3765
      @pranjalsharma3765 6 ปีที่แล้ว +1

      Tech Coach Thanks Vivek for ur reply, it's grt to know u r wrking on these topics. I have watched n subscribed ur video 🙂

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks a lot buddy, Your help will go a long way with me.

  • @dhanrajshunkalwar7098
    @dhanrajshunkalwar7098 6 ปีที่แล้ว

    Very nice explained ... Please explain all the types of indexes

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks a lot for the kind words I am in process of completing the indexing series.
      I would really appreciate if you help me in my new Initiative "An Indian Abroad"
      by subscribing viewing and sharing.
      th-cam.com/users/AnIndianAbroadd

    • @ravikhanna29
      @ravikhanna29 6 ปีที่แล้ว

      good video

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Ravinder Khanna Thanks a lot for the kind words, I am working on this new video channel " An Indian abroad" I would really appreciate if you watch and subscribe to it .
      th-cam.com/video/HBQHekM1U2c/w-d-xo.html

  • @gauravwairagade1490
    @gauravwairagade1490 6 ปีที่แล้ว +1

    Awesome explanation.... Thank you so much Vivek.... Please post some videos for initial data validation in ETL process if possible.

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      I will be making a video on flat file validation soon, May be that will help. Thanks for the kind words :)

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Please help me in my new Initiative by subscribing sharing and watching my new youtube channel
      "An Indian Abroad"
      th-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

  • @tusharshreshth
    @tusharshreshth 4 ปีที่แล้ว

    Vivek, Thanks for sharing your knowledge with all of us. If you make an index unusable or invisible then that index will not be used in explain plan. But invisible index will be keep updated by oracle server on applicable statements like INSERT,UPDATE,DELETE. I have one question on this. Can you please explain the same by using trace on select statement?

  • @tabithab79
    @tabithab79 6 ปีที่แล้ว +1

    Great job. Can you make video on performance tuning please?

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว +1

      Thanks a lot, Sure I will try to invest some time for the same

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Please help me in my new Initiative by subscribing sharing and watching my new youtube channel
      "An Indian Abroad"
      th-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

  • @ztech4634
    @ztech4634 3 ปีที่แล้ว

    What language did you use to create and insert data into the table?

  • @tanvinator
    @tanvinator 5 ปีที่แล้ว

    Vivek, how wonderful. You make it look so simple. ☺️☺️☺️☺️

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว +1

      Thanks Tanvi for the kind words I have a small request
      I am working on this new youtube channel, I Would love it if you watch and subscribe to it as well.
      th-cam.com/video/GnVn3mPBRz4/w-d-xo.html

    • @tanvinator
      @tanvinator 5 ปีที่แล้ว

      @@TechCoach done, Sir. ☺️

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      @@tanvinator thanks a lot :)

  • @PuneetSGoyal
    @PuneetSGoyal 5 ปีที่แล้ว

    Hi vivek. Can you add more details on materialised view logs.

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว +1

      Sure Puneet, I will work on it :)

    • @PuneetSGoyal
      @PuneetSGoyal 5 ปีที่แล้ว

      Tech Coach thanks

  • @divyanamdev886
    @divyanamdev886 6 ปีที่แล้ว +2

    Ur voice is nice 👍

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks for the kind words.
      I have a small request I am working on this new youtube channel "An Indian Abroad" it will really help me if you watch and subscribe to it.
      th-cam.com/video/HBQHekM1U2c/w-d-xo.html

  • @muhammadsaadmansoor7777
    @muhammadsaadmansoor7777 5 ปีที่แล้ว +2

    put index of the lecture's topics in description of the video.

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      Great suggestion, I will do it soon.Thanks Saad Mansoor

    • @jaemiah1515
      @jaemiah1515 5 ปีที่แล้ว

      @@TechCoach will wait for tech coach! Which part of the video exactly is about "Bit Map" indexing? Thanks!

  • @MrRajanSrivastava
    @MrRajanSrivastava 6 ปีที่แล้ว

    Thanks for making this video, I have a small doubt regarding difference between INDEX UNUSABLE and INDEX DISABLE. as per my understanding DISABLE INDEX can be applied on FUNCTION BASED INDEX, and it can be later REBUILT/ENABLED. Is my understanding correct or is there any other differences?

    • @MrRajanSrivastava
      @MrRajanSrivastava 6 ปีที่แล้ว

      I appreciate your efforts and like your videos very much, and have already subscribed your channel "An Indian Abroad" :)

  • @poojaanand7325
    @poojaanand7325 4 ปีที่แล้ว

    Thank you for this video. It's really helpful. Could you please provide me with the link for different types of indexes( details like bit map, domain, partitioned etc) since this video doesn't cover that part

    • @TechCoach
      @TechCoach  4 ปีที่แล้ว

      Thanks Pooja for the kind words ,
      This playlist will help you :)
      Indexes in Oracle: th-cam.com/play/PLUWdEQb_2yqVXnx-P1881VVtec8moW1sk.html

    • @bostonarchie6639
      @bostonarchie6639 3 ปีที่แล้ว

      i guess im randomly asking but does someone know a way to get back into an instagram account..?
      I was stupid lost the account password. I would love any tips you can give me.

    • @titanbarrett6837
      @titanbarrett6837 3 ปีที่แล้ว

      @Boston Archie Instablaster =)

    • @bostonarchie6639
      @bostonarchie6639 3 ปีที่แล้ว

      @Titan Barrett thanks so much for your reply. I found the site thru google and I'm waiting for the hacking stuff now.
      Seems to take quite some time so I will get back to you later with my results.

    • @bostonarchie6639
      @bostonarchie6639 3 ปีที่แล้ว

      @Titan Barrett it worked and I actually got access to my account again. Im so happy!
      Thank you so much you saved my account!

  • @_shubhambajaj
    @_shubhambajaj 3 ปีที่แล้ว

    When you rebuilt the index you can actually see the cost was increased by 1. Is it something that usually happens or is it just a session thing, I mean in the next session it will work effectively?? Nice vdo btw

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      @shubham it should work fine in the next run.
      Also thanks for the kind words.
      Please consider subscribing to my other channel as well. It will really help me.
      th-cam.com/video/6G1xGi-D5ow/w-d-xo.html

  • @ur8946
    @ur8946 5 ปีที่แล้ว

    select * from sales where id =1000; when you run this query as per you comment it need to travel 3 blocks how you are saying 3 block .could you pls clarify my doubt .

    • @polishettyanusha
      @polishettyanusha 3 ปีที่แล้ว

      i have the same doubt, can someone please clarrify

  • @ayush120793
    @ayush120793 6 ปีที่แล้ว +1

    Sir you are next TOM( The Oracle Master)...

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว +1

      Hahaha. Thanks Ayush for such kind words :), I am a big fan of ask tom. He has been around for decades. I am no where close to him. But I am trying to keep things simple

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว +2

      Please help me in my new Initiative by subscribing sharing and watching my new youtube channel
      "An Indian Abroad"
      th-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html

  • @jhaanvi6951
    @jhaanvi6951 6 ปีที่แล้ว

    why are captions disabled....could you please enable captions for all your videos

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      I am sorry about the captions, Unfortunately youtube is not generating captions for some of my videos. I will try to see if I can find a quick fix

  • @MrSaransh
    @MrSaransh 5 ปีที่แล้ว

    lets suppose index is invisible and we edit some data in saved data-row. will this edit won't change address of that row? if it changes the address then how can we reuse invisible index as we have older value ? Someone Plz reply

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      Invisible index is maintained in the background for every single data change, so as soon as we make it visible it will be used in the query plans again( only if it adds value)
      I hope it helps, Saransh, please reach out to me if any clarification are required

    • @MrSaransh
      @MrSaransh 5 ปีที่แล้ว

      @@TechCoach the thing is ... When our databade gets updated then if we make index visible.. will it not cost almost equal to rebuild the index. Because we don't know which reference got changed and we have to verify at all node/key of index .

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      Nope, when the index is invisible it is maintained and updated like any other index, If you make it unusable then you will have to rebuild the index

  • @kiran815
    @kiran815 5 ปีที่แล้ว

    Hi,Please can you share ppt here .

  • @mohanvilla0789
    @mohanvilla0789 6 ปีที่แล้ว

    Thanks man.. :)

    • @TechCoach
      @TechCoach  6 ปีที่แล้ว

      Thanks for the kind words.
      I have a small request I am working on this new youtube channel "An Indian Abroad" it will really help me if you watch and subscribe to it.
      If you have already subscribed thanks a lot :)
      th-cam.com/video/HBQHekM1U2c/w-d-xo.html

  • @syedanoorumar1419
    @syedanoorumar1419 4 ปีที่แล้ว

    But the tree ur specifying here is actually a b+ tree because it has all the record pointers in it's leaf nodes.

  • @Zovi-kanu
    @Zovi-kanu ปีที่แล้ว

    Sir are you providing live classes of pl plz give your contact details

  • @rameshd8436
    @rameshd8436 2 ปีที่แล้ว +1

    This that not visible this that.....

  • @starstudio7125
    @starstudio7125 5 หลายเดือนก่อน

    Create Video On Cluster or non cluster index😅

  • @TheRamesh3342
    @TheRamesh3342 3 ปีที่แล้ว

    insertion was .1 million

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      Thanks for correcting Ramesh.

  • @mrbushlied7742
    @mrbushlied7742 5 ปีที่แล้ว +1

    You inserted 100K recorda, not 1M.

    • @TechCoach
      @TechCoach  5 ปีที่แล้ว

      My apologies,I will look at it.

  • @pasarthivanitha3685
    @pasarthivanitha3685 3 ปีที่แล้ว

    Screen is not clear

    • @TechCoach
      @TechCoach  3 ปีที่แล้ว

      I am sory pasarthi, can you try watching again in HD quality once more please?
      I agree some of the content can be difficult to see on mobile

  • @starstudio7125
    @starstudio7125 5 หลายเดือนก่อน

    Create Video On Cluster or non cluster index😅