Which procedure is used to determine which statements are needed to make your materialized

The ______ procedure is used to determine which statements are needed to make your materialized view eligible for fast refresh and usable for general rewrite.

The ______ procedure is used to determine which statements are needed to make your materialized view eligible for fast refresh and usable for general rewrite.

A.
REFRESH

B.
TUNE_MVIEW

C.
REGISTER_MVIEW

D.
EXPLAIN_REWRITE

E.
REFRESH_DEPENDENT

Explanation:
The TUNE_MVIEW procedure shows you how to optimize your CREATE MATERIALIZED VIEW statement and to meet other requirements such as materialized
view log and rewrite equivalence relationship for fast refresh and general query rewrite. TUNE_MVIEW analyzes and processes the CREATE MATERIALIZED VIEW statement and generates two sets of output results: one for the materialized view implementation and the other for undoing the create materialized view operations

REF: Oracle Performance Guide – SQL Access Advisor 17-35



Leave a Reply 0

Your email address will not be published. Required fields are marked *