Go to menu
Summary Advisor Wizard back | 1 2 3 4 5 6 7 8 9 | next
Summaries are used in determining how best to use the pre-computed, aggregated data, that you may store in Materialized Views and Dimensions. Use the Summary Advisor Wizard when:
Query response time is slow
New data warehouses have been created
New dimension or fact tables have been added to your data warehouse.
The Wizard provides advice as to which materialized views should be created, dropped, or retained. You may let the Wizard help you implement the change.