I have seen bitmap index as the preferred choice in a data warehousing environment. I wanted to know reasons for that. As per my own experience, one reason is bitmap indexes are compressed and hence confined in less index space. When we have large number of FK indexes then this index space matters. Bitmap indexes will enable faster search and hence reduced response time in such cases.
I wanted to hear other reasons for this from experts.
As per my own research, bitmap works well for low cardinality columns, however DWH may not necessarily have low cardinality columns.