Can I read Optimize Materialized Views for Query Rewrite on EtoBox?

Optimize Materialized Views for Query Rewrite by phaltu_ is a document available to read on EtoBox.

What is Optimize Materialized Views for Query Rewrite about?

The document discusses three Oracle procedures - EXPLAIN_MVIEW, EXPLAIN_REWRITE, and TUNE_MVIEW - that can help optimize materialized views for maximum query rewrite. EXPLAIN_MVIEW identifies whether a materialized view can be fast refreshed and what types of queries it may rewrite. EXPLAIN_REWRITE confirms if a query will rewrite using a materialized view. TUNE_MVIEW checks if a materialized view can be further optimized.

Author

phaltu_

Language

EN