Transcript DB Index Expert

DB Index Expert
Copyright © 1998-2000 SoftTree Technologies, Inc.
DB Index Expert Mission




Proper database indexing is a crucial factor for the database
performance. Most Oracle databases have hundreds and even thousands
indexes. This large numbers of indexes and their complexity make
index tuning and monitoring a difficult task.
As time goes, even originally efficient indexes may become inefficient
due to various index distortions caused by data changes in the indexed
tables.
Oracle DBAs and developers need smart tools that can analyze all or
selected group of indexes at once then automatically suggest what
changes can be made to improve the database indexing. DB Index
Expert is specifically designed for such tasks. It is a tremendous timesaver for any Oracle DBA and developer who is serious about proper
database indexing.
DB Index Expert can recommend adding new indexes, modifying
existing indexes and dropping unnecessary indexes. With a few mouse
clicks it will gather and analyze all possible index statistics then present
them in a easy-to-read reports and graphs providing quick access to
index tuning.
To start DB Index, double click the
DB Index icon
Choose analysis options
Choose analysis method and report
options
Notes: If you are going to analyze a bunch of indexes, check “Select best
method based on object size”. DB Index Expert will pick reasonable
sample set of data for every analyzed table and index. This sample will be
sufficient to produce accurate reports with a quick response time and not
causing heavy load for your database.
Specify connection parameters
Select one or more schemas
Select one or more indexes
Index analysis is in progress...
Review DB Index analysis reports
and index tuning recommendations
The DB Index Expert provides
sophisticated index analysis results and
tuning recommendations




DB Index Expert can recommend adding new indexes,
modifying parameters of existing indexes and dropping
unnecessary indexes.
Recommendations for new indexes are based on analysis of high
impact SQL statements loaded into the Library Cache as well as
analysis of database referential integrity constraints that can
benefit from adding new indexes
Recommendations for existing indexes are based on analysis of
index cardinality, balancing, storage parameters, fragmentation,
table data statistics, and many other index efficiency factors...
Recommendations for unnecessary indexes are based on analysis
of table data, index and table design, existence of other indexes
The End