Oracle bitmap indexes are generally used to index columns that have very sparse domains such as Y/N, gender, or any other list of member values that is small in number. You get the advantage of indexing without creating in imbalanced btree if a conventional index is used. There is lots of info on bitmap indexes. They are also very common in read-mostly applications like data warehousing.

June 25, 2008
URL:http://www.drdobbs.com/database/bitmapped-to-hell/228700867

Terms of Service | Privacy Statement | Copyright © 2024 UBM Tech, All rights reserved.