Online analytical processing (OLAP) Question:

Download Job Interview Questions and Answers PDF

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.

Download OLAP Interview Questions And Answers PDF

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