BITMAP and BITMAP JOIN INDEX IN ORACLE explained

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.
#BITMAPINDEX #BITMAPJOININDEX #TechCoach

[dheemathimadhu]

very informative and its really very helpfull..

[uzzalbasak]

Nice explanation and clear concept of bitmap index.

[TheSomnath]

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 .

[RenzoCotta]

very well explained sir ... kudos to you

[sireeshaas]

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

[devanaidu]

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

[anilchahal]

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

[sireeshaas]

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

[rupshachakraborty]

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.

[shaliniguha]

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

[sjk_]

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??

[HarpreetKaur-qqrx]

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

[mvnkarun]

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