How can i prohibit bitmap indexes in SQL hints?

Question

So I'd like to create a query that allows to use indexes, but don't allow to use bitmap indexes. How can I do that?

example:

--1. use indexes

select /*+ index(sz) index(c)  */  * 
from szallit sz natural join cikk c
where pkod = 10;

--2. use indexes, but no bitmap indexes

select /*+ ?  */  * 
from szallit sz natural join cikk c
where pkod = 10;

Answer 1

You can use NO_INDEX hint in Oracle and explicite exclude an index. E.g. NO_INDEX(emp hiredate). There can be multiple excluded indexes for a table.

https://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements006.htm#SQLRF50411