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 ...

Get Oracle Database 10g Linux Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.