O'Reilly logo

Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database by Bill Padfield, Sam R Alapati, Darl Kuhn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Darl Kuhn, Sam R. Alapati and Bill Padfield 2016

Darl Kuhn, Sam R Alapati and Bill Padfield, Expert Oracle Indexing and Access Paths, 10.1007/978-1-4842-1984-3_3

3. Bitmap Indexes

Darl Kuhn, Sam R. Alapati2 and Bill Padfield3

(1)Morrison, Colorado, USA

(2)Flower Mound, Texas, USA

(3)Aurora, Colorado, USA

Bitmap indexes are best suited for data warehouse or decision support systems (DSS). Common to the data warehouse is the star schema, in which a central fact table contains all the detailed information for a particular subject, such as customer revenue, and the number of related dimension tables containing associated reference type data on a particular dimension, such as time or geography. In a star schema, the dimension tables are the parent and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required