Figure 7.8 -
SQL Tuning
Advisor - View Recommendations
-
Now that
the review
of the
SQL
Tuning Advisor
is completed,
attention
will now be shifted
to
exploring the
SQL Access Advisor.
When
there is an
application with complex queries on large sets of data, SQL Access
Advisor comes in very handy. For improving performance, it will
recommend a combination of indexes, materialized views, and
materialized view logs. These structures can result in significant
performance improvements; though they require a considerable amount
of time and space to create and maintain.
The SQL Access Advisor recommends how to
optimize materialized views to be refreshable and benefit from
general query rewrites. It also recommends the use of bitmap and
B-tree indexes. B-tree indexes are used mainly in data warehouses or
large databases to index unique or near-unique keys.
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
