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 operationsREF: Oracle Performance Guide – SQL Access Advisor 17-35