25 May 20 · rajneesh4u · #general ·   Bookmark   ×

Why bitmap index in DWH

Hello Experts,

I have seen bitmap index as preferred choice in data warehousing environment. I wanted to know reasons for that. As per my own experience, one reason is bit map index are compressed and hence confined in less index space. When we have large number of FK indexes then this index space matters. Bit map index will enable faster search and hence reduced response time in such cases. I wanted to hear other reason for same from experts.

As per my own research(below URL), bitmap works well for low cardinality columns , however need help to know more around this because DWH may not necessarily have low cardinality columns.




posted on 25 May 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

@rajneesh4u I havent worked on Bitmap indexes. Lets see if anyone from the community is familiar

ok npack !!

Community Software by Hittly