Hi Gurus
I'm trying to absorb the concept of bitmap and b-tree indexes but unable to grab those concept, so far I learn the following points:
B-Tree Index
Use in OLTP environment
It is use for those types of columns where having more unique value or we can say that high cardinality
It occupy less storage
Use of matched pattern and ranges
By default Oracle uses b-tree indexing
Bitmap Index
Use in OLAP environment/Data ware house
It is use for those types of columns where repeated values exist or we can say that low cardinality, example are Male and Female
Looks like those points related to difference between both indexes. I really appreciate if someone provide me more explanation about those topics.
Thanks in advance
Regards
Muzz