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;