Re: Performance: BITMAP index vs. Non-Bitmap Index

From: <antonberg1_at_gmx.de>
Date: 19 Apr 2006 05:01:06 -0700
Message-ID: <1145448066.578311.111720@u72g2000cwu.googlegroups.com>

Hello,

the explain plan is:
SELECT STATEMENT
SORT GROUP BY
PARTITION RANGE INLIST

      TABLE ACCESS BY LOCAL INDEX ROWID 4*TABLE1
        BITMAP CONVERSION TO ROWIDS
          BITMAP INDEX RANGE SCAN TABLE1_INDEX

The faster explain plan without the BITMAP Index is: SELECT STATEMENT
SORT GROUP BY
PARTITION RANGE INLIST

      INLIST ITERATOR
        TABLE ACCESS BY LOCAL INDEX ROWID 4*TABLE1
          INDEX RANGE SCAN TABLE1_INDEX

Btw. what is this BITMAP-Index? Maybe you can point me to some information on this theme?

Thanks a lot for your help,
Anton Received on Wed Apr 19 2006 - 07:01:06 CDT