Why bitmap index in DWH
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.
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