This tutorial will identify some use cases for Oracle bitmap indexes, including some of the more advanced capabilities. See all lessons, free, at http://www.skillbuilders.com/when-to-use-oracle-bitmap-indexes.
Indexing your Oracle Database for best performance? There are cases, depending on data structures and queries, where b-tree indexes are not useful (e.g. scan access paths perform inadequately). In these cases, bitmap indexes may be a better solution.
Bitmap indexes are a powerful tool, but they need to be used with care. Inappropriate use may cause problems worse than those they solve.
The tutorial covers somewhat more advanced cases such as using bitmap join indexes to denormalize a snowflake schema, and to enable star transformations in queries that join fact tables to several dimension tables.
This training will benefit any Oracle DBA administering a Data Warehouse or VLDB and "power" developers working in same.
Instructor: Oracle Certified Master DBA John Watson, SkillBuilders
Indexing your Oracle Database for best performance? There are cases, depending on data structures and queries, where b-tree indexes are not useful (e.g. scan access paths perform inadequately). In these cases, bitmap indexes may be a better solution.
Bitmap indexes are a powerful tool, but they need to be used with care. Inappropriate use may cause problems worse than those they solve.
The tutorial covers somewhat more advanced cases such as using bitmap join indexes to denormalize a snowflake schema, and to enable star transformations in queries that join fact tables to several dimension tables.
This training will benefit any Oracle DBA administering a Data Warehouse or VLDB and "power" developers working in same.
Instructor: Oracle Certified Master DBA John Watson, SkillBuilders
- Category
- Success
Sign in or sign up to post comments.
Be the first to comment