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 .
I have a humble request somnath, If you can share my new channel with your friends as well it will really help me . th-cam.com/video/HBQHekM1U2c/w-d-xo.html
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
Thanks Pradeep for your wonderful comment. It will really help me if you watch and subscribe to my new channel. th-cam.com/video/HBQHekM1U2c/w-d-xo.html
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
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
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
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.
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??
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
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.
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. th-cam.com/video/Oz4TbQwrrOY/w-d-xo.html
![เปิดบ้าน โคตรสวย ป๋องกพล รู้จักตั้งนาน เพิ่งรู้ว่ารวย!!! l [Nickynachat]](http://i.ytimg.com/vi/tmgCF_2HfYI/mqdefault.jpg)
Nice explanation and clear concept of bitmap index.
Thanks a lot buddy , I am glad I could help.
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 .
:) Excellent reply Somnath
I have a humble request somnath, If you can share my new channel with your friends as well it will really help me .
th-cam.com/video/HBQHekM1U2c/w-d-xo.html
Surely , Tech Coach . You are such a humble person doing excellent job .
very well explained sir ... kudos to you
very informative and its really very helpfull..
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
I think multiple single bitmap index are better than composite bitmap index to avoid deadlock.Well Explained
Thank You!
I am glad I could help:)
Excellent.. Really helpful.
Thanks Pradeep for your wonderful comment. It will really help me if you watch and subscribe to my new channel.
th-cam.com/video/HBQHekM1U2c/w-d-xo.html
You are genius!
Thanks a lot Suchita for the kind words :)
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
Can you please tell one scenario where bitmap index is inevitable and we can’t consider using btree index?
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
Sure buddy I will work on it soon :)
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
Wow good video
Thanks a lot for the kind words :)
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.
kir khar vasat lahjatoon
thanks bro
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??
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
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.
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.
th-cam.com/video/Oz4TbQwrrOY/w-d-xo.html
@@TechCoach ...Sure...I have subscribed to it
Thanks a lot buddy :)
Composite index