{マテビュー}DBMS_MVIEW.EXPLAIN_MVIEWにより高速リフレッシュ、クエリリライト可能か確認する

https://docs.oracle.com/cd/F19136_01/dwhsg/basic-materialized-views.html#GUID-651B08EB-4D32-4A93-A260-A965C40AE136

conn sh/sh

@?/rdbms/admin/utlxmv.sql

truncate table MV_CAPABILITIES_TABLE;
exec DBMS_MVIEW.EXPLAIN_MVIEW ('product_sales_mv');
select * from MV_CAPABILITIES_TABLE;

truncate table MV_CAPABILITIES_TABLE;
exec DBMS_MVIEW.EXPLAIN_MVIEW ('detail_sales_mv');
select * from MV_CAPABILITIES_TABLE;

truncate table MV_CAPABILITIES_TABLE;
exec DBMS_MVIEW.EXPLAIN_MVIEW ('join_sales_cust_time');
select * from MV_CAPABILITIES_TABLE;

truncate table MV_CAPABILITIES_TABLE;
exec DBMS_MVIEW.EXPLAIN_MVIEW ('sum_sales_cust_time');
select * from MV_CAPABILITIES_TABLE;