| |
 |
|
Oracle 8 Tips
by Burleson Consulting |
The Data Warehouse Development Life Cycle
Oracle Features for the Data Warehouse
Understanding Oracle indexes
One of the primary responsibilities of the Oracle Remote DBA is ensuring
that Oracle indexes are present when they are needed to avoid
full-table scans. In order to achieve this goal, the Oracle Remote DBA
needs to understand the types of indexes that Oracle provides as
well as the proper time to create a table index.
Unfortunately, the Oracle dictionary does not gather statistics
about how many times an index is used, so the Remote DBA must rely upon the
application developers to provide guidance regarding index
placement. As Oracle moves toward Oracle 8, this reliance on the
application developers may change since most of the SQL will be
stored within the Oracle dictionary where the Remote DBA can analyze the
explain plan output. However, until that time, the best that an
Oracle Remote DBA can hope for is to keep the existing indexes clean and
functioning optimally.
|
