Online analytical processing (OLAP) Question:

Explain about Encoding technique used in bitmaps indexes?

OLAP Interview Question
OLAP Interview Question

Answer:

Bitmaps commonly use one bitmap for every single distinct value. Number of bitmaps used can be reduced by opting for a different type of encoding. Space can be optimized but when a query is generated bitmaps have to be accessed.


Previous QuestionNext Question
Explain about the role of bitmap indexes to solve aggregation problems?Explain about Binning?