Bitmap index Database index
a bitmap index special kind of indexing stores bulk of data bit arrays (bitmaps) , answers queries performing bitwise logical operations on these bitmaps. commonly used indexes, such b+ trees, efficient if values index not repeat or repeat small number of times. in contrast, bitmap index designed cases values of variable repeat frequently. example, sex field in customer database contains @ 3 distinct values: male, female or unknown (not recorded). such variables, bitmap index can have significant performance advantage on commonly used trees.
Comments
Post a Comment