Oracle Tips by Burleson
Chapter 8 Oracle Index
The bitmapped index was added in Oracle7.3.2.
Indexes were expanded to include partitions in Oracle8, in addition
to the old monitoring requirements. In Oracle8i, partitioning was
further expanded to include sub-partitions and the additional
functionality of function-based indexes, as well as indextypes.
Oracle8i also added support for descending indexes. To those
capabilities, Oracle9i added the bitmap join index and the skip scan
The DBA still needs to monitor table indexes to
verify uniqueness, determine if the appropriate columns have been
indexed, and determine proper ownership of indexes for a given
application in Oracle9i. The DBA also needs a convenient reference
to show which tables have indexes, as well as what is indexed, in
case of the loss of a table or for use during table maintenance. The
diagram in Figure 8.1 shows the cluster of dba_ views that are
needed for monitoring indexes.
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link: