Reverse Key Index :Types of Btree Index in Oracle

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ธ.ค. 2024

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

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

    Well explained to details!!!!!!!!!

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

      Thanks buddy :)

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

    Superb!! Very nicely Explained.

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

      Thanks Jagadish for the kind words :)

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

    Excellent explanation

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

    Awesome Man!!!! you made learning easy.
    Please make some real live performance problem videos. till now no one has posted good perf vidoes.

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

    Very simple and nice explanation!

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

      Thanks Doshin 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

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

    Hi Vivek, Excellent information with crystal clear explanation.

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

      Thanks Naga for the kind words, I have a small request , I am working on this new channel please do watch share and subscribe to it.
      Your support is my motivation.
      th-cam.com/video/Oz4TbQwrrOY/w-d-xo.html

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

    Awesome video as always. Thanks for all these videos.

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

      Thanks a lot, please subscribe to my new channel :) th-cam.com/users/AnIndianAbroadd

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

    Thanks so much Vivek. Your videos are really help for me.

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

    content of this playlist is superb,
    how to delete partitions like indexes are unusable and un visible is there any way to drop only partitions

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

      Yes we can drop partitions easily with drop partition partition_name command

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

    Hello Vivek,
    I started watching one video and your training quality provoked me to watch all videos...Its like Happy learning for me
    Just one suggestions, if you add which part of topic help us on interviews that would be great help.
    Very nice elaboration ..

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

      Thanks a lot for the kind words kalyani, I will try to make more interview videos. I have a small request, I am working on this new channel and will really appreciate if you watch and subscribe to it.
      th-cam.com/video/IP2Vn6jK8Hg/w-d-xo.html

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

    You are good in teaching

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

      Thanks a lot, please subscribe to my new channel :) th-cam.com/users/AnIndianAbroadd

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

      Tech Coach Already sirji since your 1k subscriber 🙂

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

      sachin mandlik This is a new channel, Please subscribe and share with your friends :)

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

    If you can upload the video about stale stats . When do we have to go for index rebuild?

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

    Exellent! Thank you ! Please do a video on Index fragmentation and do we really need to rebuild indexes

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

      Thanks for the kind words, Sure I will work on it.

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

    Firstly i want to appreciate the great work you have done man....i have a small doubt. As you have mentioned column ids will be stored in reverse manner as 301 will be stored as 103 in earlier blocks, there is already 103 present in there. how will it work then? there will be 2 records with 103.. please help me in understanding

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

    Amazing channel

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

      Thanks Neeraj :)

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

    thank u sir

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

      Thanks buddy for the kind words.
      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

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

    What is inlist iterator?

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

    Hi Vivek, excellent videos, one small request, kindly zoom your screen while executing the code, as the small alphabets in code editor cannot be seen on your screen, either enlarge the fonts or zoon in so that things can be properly viewed as you work on the coding part.

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

      Thanks Kaustubh for the wonderful tip, I will improve this in my upcoming videos :).

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

    Hi,
    Great series! I like your tutorials.
    I have a suggestion. Can you please start numbering these video titles? This will add more clarity on the number of videos in the series and it also helps in viewing them sequentially.

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

      Thanks Syed for the wonderful idea. I will implement it for my new video series.
      I have a small request 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

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

    Hi Vivek,please do more videos on performance tuning concepts

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

      Sure Soumya, I will work on it soon

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

      @@TechCoach thanks ...I have cracked two interviews after watching your video

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

      @@soumyashrivastava4859 your comment made my day :).

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

      Yes please share more videos like this for SQL and plsql

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

    for any query and question how should commuicate

  • @ramakrishna-dy8vj
    @ramakrishna-dy8vj 3 ปีที่แล้ว

    I have a doubt. if the value which is going to be inserted is 301 will be iserted as 103 under the ranges of 101 to 200. if its 302 , will be under the range of 201 to 300 as 203. If its 304, the reverse of it is 403. But there is no range of block with 401 to 500 right? I didn't understand Properly . Please guide me

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

    Please make video on copy ,no copy parameter

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

      Sure Kiran, I will work on it.
      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/11DK-oyRql0/w-d-xo.html

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

      Tech Coach thanks..