 |
|
Oracle Tips by Burleson |
Oracle Index Administration
Overview
This tutorial introduces indexing within a
relational database and the primary purpose for indexes within the
Oracle sub-system. The topic of this tutorial include a review of the
basic types of Oracle indexes, including b-tree indexes, bitmap
indexes, function-based indexes, as well as specialized star indexes
that are used in Oracle data warehouses. We will also look at
specialized index access methods for SQL, including bitmap join
indexes and index skip scans.
The tutorial will take a look at the b-tree
index, and contrast the b-tree with the bitmap indexes so you will
understand when bitmap indices are appropriate for Oracle indexing.
This tutorial will also examine function-based indexes to see how
unnecessary large-table full-table scans can be virtually eliminated
within the Oracle database.
This tutorial will also examine the monitoring
all of Oracle index usage, and identification of those conditions that
are mapped when necessary to rebuild Oracle indexes.
This tutorial wraps up with a discussion of
how to use Oracle SQL query hints and optimizer plan stability in
order to force the use of an Oracle index.
Learning Outcomes
Upon completion of this tutorial, you will be
able to:
* Explain Oracle index types
* Diagram Bitmap Indexes
* Create function-based indexes
* Monitor index statistics and usage
* Rebuild Oracle indexes
* Force the use of indexes
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
|
