Reporting on Bitmap Indexes
It is fairly simple to get information on bitmap indexes from the data dictionary. See the following query from the USER_INDEXES view in order to get information on both bitmap and bitmap join indexes:
SELECT index_name, index_type, join_index FROM dba_indexes
WHERE index_type = 'BITMAP';
INDEX_NAME INDEX_TYPE JOI
------------------------------ --------------------------- ---
BILLING_FACT_BIXFK102 BITMAP NO
BR_FACT_BJIX002 BITMAP YES
If you want to get the specific join information on any bitmap join indexes you have in your database, you can get this information from the USER_JOIN_IND_COLUMNS data dictionary ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
