Indexes are one of the primary ways you can enhance the performance of your database. The Oracle9i database has a number of enhancements that improve and enhance the capabilities of the indexes you can use.

In this module, you will learn how to:

1. Describe the types of indexes that can be created in Oracle9i
2. Create a descending index
3. Describe the bitmap index improvements of Oracle9i
4. Create a reverse index
5. Describe two methods of creating statistics
6. Describe the new Oracle9i feature of domain indexes
7. Use the ONLINE parameter for indexes
8. Define function-based indexing
9. Create a function-based index

Oracle9i significantly expands the type and variety of performance improvements you can achieve with indexes.
In the next lesson, we will describe index types.