CHAPTER 17Indexes and Partitioning
This chapter focuses on a couple of important tuning topics: indexing and partitioning. Indexes store key values and row IDs (physical row addresses); in most cases, they can greatly decrease the response time of SQL. Partitioning is a way of subdividing larger objects into smaller pieces. Applications can use partitioning to easily delete data and load it while not affecting other users. These smaller pieces are easier to manage (backup and recovery) and, when used with the proper knowledge, can have considerable performance benefits.
Introduction to Oracle 10g Indexing Options
Oracle 10g supports both B*Tree index structures and bitmap index structures. The table object has a pseudo-column called ROWID. A ...