| |
 |
|
Oracle Tips by Burleson Consulting |
Analyzing Indexes
For Oracle8, Oracle8i, and Oracle9i, the
ANALYZE command can be used to get the average index size from an
example index. The format of this command follows. Other statistics
are also generated, but these will be covered in Chapter 9.
where:
See Code Depot
The results appear in the INDEX_STATS
view, and some of the statistics also appear in the *_INDEXES series
of views (DBA, USER, and ALL). One thing to remember is that, unlike
the DBA_TABLES view, only one row at a time is saved in the
INDEX_STATS view, the row for the last index analyzed.
www.dba-oracle.com/oracle_scripts.htm |
