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.

Thanks,

Rajneesh

rajneesh4u

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




npackMay 29 12:42

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

rajneesh4uMay 30 02:11

ok npack !!


Community Software by Hittly