
4.5 Making Materialized Views Faster 109
Chapter 4
BEGIN
DBMS_ADVISOR.TUNE_MVIEW(mvname, 'CREATE MATERIALIZED
VIEW sales_by_city ENABLE QUERY REWRITE AS SELECT l.region AS
region,l.country AS country,l.city AS
city,SUM(transaction_amount) AS amount FROM sale s, location
l WHERE s.location_id = l.location_id GROUP BY
l.region,l.country,l.city');
END;
/
SELECT * FROM USER_TUNE_MVIEW;
Note: The ADVISOR system privilege is required to access the
DBMS_ADVISOR package.
Details have not been provided in this situation, because in the past I
have had lackluster results from Oracle Database expert tuning advisory
tools. They are primitive at best, and dangerous ...