Chapter 13. Oracle9i Indexing Options

This chapter begins the next section of the book that covers various tuning issues. Chapter 13 starts with coverage of the Oracle9i Indexing features and options. Since indexing plays a major role in the fast retrieval of information within the Oracle database, it is essential that the reader understands indexing, how it works, and the various options and features available in Oracle 9i.

This chapter teaches you the following:

• B-tree indexes

• How IOTs are useful

• Various Oracle9i indexing options and features

• How to use these options and features in a real application