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:
How IOTs are useful
Various Oracle9i indexing options and features
How to use these options and features in a real application