In Oracle 12c, one can have more than one index on the same columns, i.e., a b-tree index and a bit map index. It looks great until one finds that only one index can be visible, other indexes have to be invisible. Why Oracle has such a retsriction. Only way I can take advnatge of invisible index is to use hint in my query to use invisible index!!