When to use Oracle Bitmap Indexes, Tips for Data Warehouse – Free Tutorial
Duration: 50 minutes
Indexing your VLDB Oracle Database or Data Warehouse 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.
This free tutorial will identify some use cases for bitmap indexes, including the more advanced capabilities for Data Warehouse: using bitmap join indexes to denormalize a snowflake schema, and to enable star transformations in queries that join fact tables to several dimension tables (time permitting). John will also demonstrate how to achieve star transformation EVEN IN STANDARD EDITION!
Bitmap indexes are a powerful tool, but they need to be used with care. Inappropriate use may cause problems worse than those they solve.
This training will benefit any Oracle DBA administering a Data Warehouse or VLDB and “power” developers working in same.
A general understanding of b-Tree indexes is required. A General understanding of Oracle execution plans is very helpful for the demonstrations. Here’s a great tutorial on reading execution plans if you would like a primer or review.
- Lectures 6
- Quizzes 0
- Duration 50 minutes
- Skill level All levels
- Language English
- Students 17
- Certificate No
- Assessments Yes