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

Precise Pb.E2.80.93Pb dating of meteorites Lead–lead dating

Administrative and offices Campus of the University of Montana

Understanding the dangers Tornado preparedness