Free Oracle Tips

Oracle Consulting Oracle Training Development
Oracle Training
SQL Tuning Consulting
Oracle Tuning Consulting
Data Warehouse Consulting
Oracle Project Management
Oracle Security Assessment
Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Internals Magazine
Oracle Links
Oracle Monitoring
Remote Support Benefits
Remote Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 


        
 
 Oracle bitmap index structure

 

Question:

 How the BITMAP index is stored?.  Basically i want to know the way a bitmap index is stored inside Oracle.  I have the basic idea that the bitmap index will create a bitmap for each distinct value exist in the table and accordingly it will  have the start rowid and end rowid mapped to the bitmap index.

Answer:

Bitmap indexes are stored as an array of zero-and-one values, with one entry for each row.  Bitmaps are created by doing a full-table scan of the indexed table, and they are very slow for updates.  Here are tips on using bitmap indexes:

 http://www.dba-oracle.com/oracle_tips_bitmapped_indexes.htm

     


 

Free Oracle dictionary reference poster

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

North Carolina Oracle Users Group

 

 Arabian horse breeder

Seeing eye horses

 

 

 

 

 

BC Remote Oracle Support
P.O. Box 511 • Kittrell, NC, 27544

Copyright © 2007 by Burleson Enterprises, Inc. All rights reserved.