Assertion: rewrite | /r/HasProperty | possible
Facets:
value: with stale materialized view sales_per_country_mv
type: OTHER
Source sentences:
text: This process continues until no further rewrites are possible.
text: Now sales_per_country_mv is stale, but PCT rewrite (in ENFORCED and TRUSTED modes) is possible as this materialized view supports PCT against table sales_par_list .
text: This query accesses partitions America and Asia in sales_par_list ; these partition have not been updated so rewrite is possible with stale materialized view sales_per_country_mv as this query will access only FRESH portions of the materialized view.
text: Now sales_per_dt_partition_mv is stale, but PCT rewrite (in ENFORCED and TRUSTED modes) is possible as this materialized view supports PCT (pmarker based) against table sales_par_list .