Although we have covered indexes extensively in the series, there are still some obscure index features that you can use to greatly promote
the performance of your Oracle queries. While all indexes serve to avoid the costly full-table scan, Oracle has developed a wealth of new indexing options that can speed certain types of queries.
This module discusses the benefits of
- bitmapped indexes,
- STAR query operations,
- STAR transformation queries,
- a concatenated index, and
- a function-based index.
By the time you complete this module you should be able to:
Explain the benefits of bitmapped indexes
Describe a STAR query operation
Describe a STAR transformation query
Create a concatenated index
Describe a function-based index
The next lesson reviews the limitations of standard Oracle indexes to understand why the new indexing methods were created.