Search notes:

Oracle SQL Plan operation BITMAP INDEX RANGE SCAN

create table tq84_tab (
   val      number,
   pad      varchar2(100)
);


insert into tq84_tab
select
   mod(rownum, 1000),
   rpad('*', 100, '*')
from
   dual connect by level <= 1000;

create bitmap index tq84_tab_ix_bmp on tq84_tab(val);

begin
   dbms_stats.gather_table_stats(user, 'tq84_tab');
end;
/

explain plan for
select * from tq84_tab where val between  499 and 501;

select * from table(dbms_xplan.display(format=>'basic'));
--
-- ---------------------------------------------------------------
-- | Id  | Operation                           | Name            |
-- ---------------------------------------------------------------
-- |   0 | SELECT STATEMENT                    |                 |
-- |   1 |  TABLE ACCESS BY INDEX ROWID BATCHED| TQ84_TAB        |
-- |   2 |   BITMAP CONVERSION TO ROWIDS       |                 |
-- |   3 |    BITMAP INDEX RANGE SCAN          | TQ84_TAB_IX_BMP |
-- ---------------------------------------------------------------

drop table tq84_tab;

See also

BITMAP INDEX SINGLE VALUE
Plan operations

Index