Ellis Miller's blog

Ellis Miller's picture

Analyzing Materialized Views for Fast Refresh

articles: 

This article shows how materialized views can be analyzed and optimized to ensure they can be FAST REFRESHed. As tools, the DBMS_MVIEW.explain_mview procedure and the MV_CAPABILITIES_TABLE are used. In this particular case, refresh time was reduced from more than 14 hours to less than 2!

Subscribe to RSS - Ellis Miller's blog