Index - Bitmap

Card Puncher Data Processing

About

Relation - Bitmap Indexes in Oracle

BITMAP CONVERSION TO ROWIDS

nico@ORCL>select * from emp where job = 'CLERK' or job = 'MANAGER';

Execution Plan
-----------------------------------------------------------------------------------------
| Id  | Operation                     | Name    | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT              |         |     7 |   609 |     2   (0)| 00:00:01 |
|   1 |  INLIST ITERATOR              |         |       |       |            |          |
|   2 |   TABLE ACCESS BY INDEX ROWID | EMP     |     7 |   609 |     2   (0)| 00:00:01 |
|   3 |    BITMAP CONVERSION TO ROWIDS|         |       |       |            |          |  <-------- Here
|*  4 |     BITMAP INDEX SINGLE VALUE | JOB_IDX |       |       |            |          |
-----------------------------------------------------------------------------------------

We need for this query to get to the table. Here, Oracle will apply a function to turn the fact that i'th bit is on in a bitmap, into a rowid that can be used to access the table.





Discover More
Card Puncher Data Processing
Oracle Database - Index (indices)

in Oracle Create Statement for columns table: The LOGGING/NOLOGGING setting determines if operations are...



Share this page:
Follow us:
Task Runner