Thus, all of the materialized views had been created with REFRESH FORCE ON DEMAND and a COMPLETE refresh of all 12 materialized views was taking less than an hour. Upon the first release of the application largest tables had no more than several hundred thousand rows. In this particular case, refresh time was reduced from more than 14 hours to less than 2!Ī recent assignment tasked our team with analyzing 12 existing materialized views comprising the reporting engine of an in-house Oracle 9i budgeting application. ![]() As tools, the DBMS_MVIEW.explain_mview procedure and the MV_CAPABILITIES_TABLE are used. This article shows how materialized views can be analyzed and optimized to ensure they can be FAST REFRESHed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |