be careful with bitmap indexes - you don't want to use them if the underlying table is changing very much. bitmap indexes are best in static tables (and yes with low cardinality)