BITMAP and BITMAP JOIN INDEX IN ORACLE explained

Подписаться 33 тыс.

Просмотров 24 тыс.

50% 1

The video explains BITMAP and BITMAP JOIN INDEX IN ORACLE and when you should create them on a column.
BITMAP INDEXES should be dealt with carefully as they can lead to serious performance issues if the table is updated by multiple processes in parallel.
Indexing Basics : • Indexing in Oracle :B-...
Star and snowflake Schema : • Star and Snowflake sch...
#BITMAPINDEX #BITMAPJOININDEX #TechCoach

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

2 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@RenzoCotta Год назад

very well explained sir ... kudos to you

@gustavsgulbis7356 2 месяца назад

Thank You!

@TechCoach 2 месяца назад

I am glad I could help:)

@dheemathimadhu847 5 лет назад

very informative and its really very helpfull..

@uzzalbasak2517 2 года назад

Nice explanation and clear concept of bitmap index.

@TechCoach 2 года назад

Thanks a lot buddy , I am glad I could help.

@sireeshaas7680 3 года назад

Hi Tech Coach, Nice explanation. Can you please give answers to the 2 questions asked in this video? Also if possible pls make 'Bitmap Join' index video with different examples , as in the video it's felt so quick for this concept

@TheSomnath2000 6 лет назад

Brilliant as usual :) . Referring to your first question use of BITMAP INDEX on a particular column or composite column BITMAP Index . I think it depends on the selectivity criteria on the data set which we will run . Accordingly, we will get the performance benefit .

@TechCoach 6 лет назад

:) Excellent reply Somnath

@TechCoach 6 лет назад

I have a humble request somnath, If you can share my new channel with your friends as well it will really help me . ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HBQHekM1U2c.html

@TheSomnath2000 6 лет назад

Surely , Tech Coach . You are such a humble person doing excellent job .

@ThePradeeppapu 6 лет назад

Excellent.. Really helpful.

@TechCoach 6 лет назад

Thanks Pradeep for your wonderful comment. It will really help me if you watch and subscribe to my new channel. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HBQHekM1U2c.html

@iamkirankumarkv Год назад

thanks bro

@anilchahal1254 5 лет назад

I think multiple single bitmap index are better than composite bitmap index to avoid deadlock.Well Explained

@sireeshaas7680 3 года назад

Hi, Can you please make a video on Clustered/Non-clustered Index ,Filtered,Hash index ? Please continue making videos on Oracle concepts ,we miss your videos

@devanaidu9406 6 лет назад

Hi bro..very nice explanation thank you for sharing your knowledge your all videos are vey help ful us..keep sharing bro and pls share PL/SQL concepts like PROCEDURES,FUNCTIONS,PACKAGES,CURSORS,REF CURSORS,COLLECTIONS,TRIGGERS BRO..Pls make as soon as possible bro..we are waiting those PL/SQL concepts from you bro

@TechCoach 6 лет назад

Sure buddy I will work on it soon :)

@HarpreetKaur-qq8rx Год назад

Hi, how does having 1s and 0s in index prevents full table scan. And why does query execution engine able to go to precisely that rows which contains the desired value

@rupshachakraborty6059 3 года назад

I think a single composite bitmap column which has been shown in the video is more preferable in case of gender and marital status column (to fetch data logically) instead of using 32 single bitmap indexes. Please correct me if I am wrong.

@shaliniguha1822 8 месяцев назад

Can you please tell one scenario where bitmap index is inevitable and we can’t consider using btree index?

@suchitasinha4808 3 года назад

You are genius!

@TechCoach 3 года назад

Thanks a lot Suchita for the kind words :)

@sjk_88 3 года назад

If I have a table with continuous stream of inserts (no updates or deletes, only inserts) is it still not recommended to have bitmap index for some of the column, because of deadlock concerns??

@mittuvalasa6528 3 года назад

Wow good video

@TechCoach 3 года назад

Thanks a lot for the kind words :)

@mvnkarun592 4 года назад

Hi Vivek, Thanks for the vedio. Its very helpful. I have a question on a Table parallel updates will not be possible right? If a update is started until and unless this is committed the other update/delete will not be happen right? Can you please share your inputs

@TechCoach 4 года назад

You are right arun, table level locking is the reason why parallel updates are not possible, for the same reason bitmap indexes are highly discouraged when there are chances of parallel updates.

@TechCoach 4 года назад

Thanks Arun for the kind words. I have a small request, I am working on this new channel please do watch 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

@mvnkarun592 4 года назад

@@TechCoach ...Sure...I have subscribed to it

@TechCoach 4 года назад

Thanks a lot buddy :)