Тёмный

Reverse Key Index :Types of Btree Index in Oracle 

Tech Coach
Подписаться 34 тыс.
Просмотров 10 тыс.
50% 1

Please subscribe to my new channel.
/ anindianabroadd
The Videos explains how Reverse Btree Index works and in what condition they shall be used.
Reverse Btree index are used to solve index block contention.
#ReverseKeyIndex #BtreeIndex #TechCoach
You can't perform range scans in reverse btree Index.

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

 

30 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 46   
@yarramneediravindraswamy6804
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 Год назад
Yes we can drop partitions easily with drop partition partition_name command
@ramakrishna-dy8vj
@ramakrishna-dy8vj 2 года назад
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
@nimmylizthomas
@nimmylizthomas 2 года назад
Well explained to details!!!!!!!!!
@TechCoach
@TechCoach 2 года назад
Thanks buddy :)
@govindkota1026
@govindkota1026 2 года назад
for any query and question how should commuicate
@anushreeghosh4928
@anushreeghosh4928 2 года назад
What is inlist iterator?
@JagadishVarodiya
@JagadishVarodiya 3 года назад
Superb!! Very nicely Explained.
@TechCoach
@TechCoach 3 года назад
Thanks Jagadish for the kind words :)
@kalyanik4804
@kalyanik4804 5 лет назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IP2Vn6jK8Hg.html
@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
@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.
@sunilkumarkaushal8594
@sunilkumarkaushal8594 6 лет назад
Awesome video as always. Thanks for all these videos.
@TechCoach
@TechCoach 6 лет назад
Thanks a lot, please subscribe to my new channel :) ru-vid.com
@ducchibui
@ducchibui 5 лет назад
Thanks so much Vivek. Your videos are really help for me.
@tamahesh
@tamahesh 6 лет назад
If you can upload the video about stale stats . When do we have to go for index rebuild?
@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Oz4TbQwrrOY.html
@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 :).
@pvarss7163
@pvarss7163 5 лет назад
Excellent explanation
@oracledbatamil7127
@oracledbatamil7127 5 лет назад
Exellent! Thank you ! Please do a video on Index fragmentation and do we really need to rebuild indexes
@TechCoach
@TechCoach 5 лет назад
Thanks for the kind words, Sure I will work on it.
@kirandalvi3406
@kirandalvi3406 6 лет назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-11DK-oyRql0.html
@kirandalvi3406
@kirandalvi3406 6 лет назад
Tech Coach thanks..
@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-11DK-oyRql0.html
@soumyakantapradhan4212
@soumyakantapradhan4212 6 лет назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HBQHekM1U2c.html
@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GnVn3mPBRz4.html
@sachin1234566
@sachin1234566 6 лет назад
You are good in teaching
@TechCoach
@TechCoach 6 лет назад
Thanks a lot, please subscribe to my new channel :) ru-vid.com
@sachin1234566
@sachin1234566 6 лет назад
Tech Coach Already sirji since your 1k subscriber 🙂
@TechCoach
@TechCoach 6 лет назад
sachin mandlik This is a new channel, Please subscribe and share with your friends :)
@neerajshukla6907
@neerajshukla6907 4 года назад
Amazing channel
@TechCoach
@TechCoach 4 года назад
Thanks Neeraj :)
@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 лет назад
@@soumyashrivastava4859 your comment made my day :).
@soumyashrivastava4859
@soumyashrivastava4859 5 лет назад
Yes please share more videos like this for SQL and plsql
Далее
Functional Indexes in Oracle
11:42
Просмотров 6 тыс.
Index Organized Table in Oracle|IOT Oracle|Tech Coach
19:10
Обменялись песнями с POLI
00:18
Просмотров 109 тыс.
Indexing in Oracle :B-Tree,Bitmap Indexing
25:47
Просмотров 89 тыс.
LEARN BITMAP INDEXES
13:20
Просмотров 72 тыс.
Range Partitioning in Oracle
15:00
Просмотров 24 тыс.
BITMAP  and  BITMAP JOIN INDEX IN ORACLE explained
25:12
Database Indexing for Dumb Developers
15:59
Просмотров 61 тыс.
Oracle indexes
14:46
Просмотров 20 тыс.
Indexes in Oracle :Index Scan Methods :Part 2
30:18
Просмотров 36 тыс.
Обменялись песнями с POLI
00:18
Просмотров 109 тыс.