Bitmap indexes in high-cardinality column
Sorry about the simple question, but my knowledge in DWH is very limited. What is the point to have BITMAP index in a DATE type column, with very high-cardinality on a Datawarehouse, besides of the index size? As far as I know bitmap indexes works better in low-cardinality columns, what concept am I missing here?
Thanks,
DBABR