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

Popular posts from this blog

File format Wavefront .obj file

CEFR alignment Euroexam International

Books Soma Valliappan