Netvouz / MondoTofu / tag / views http://netvouz.com/MondoTofu/tag/views?feed=rss MondoTofu's bookmarks tagged "views" on Netvouz Brief introduction into Materialized Views http://uhesse.com/2009/07/08/brief-introduction-into-materialized-views/ The Oracle Instructor Tune Materialized views Oracle > PL/SQL 11g MondoTofu Tue, 20 Aug 2013 00:25:12 GMT How to “MAX” out your Fast Refresh Materialized Views - Blue Gecko http://www.bluegecko.net/oracle/how-to-max-out-your-fast-refresh-materialized-views/ DBMS_ADVISOR.TUNE_MVIEW, Oracle > DB 11g MondoTofu Thu, 24 Jul 2014 13:37:22 GMT Reclaiming Wasted Space Oracle 11g Viewing Segment Advisor Results http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm#CBBJHIGH Segment space advisor, DBA_RECOMMENDATIONS shrink compact savings Oracle > DB 11g MondoTofu Wed, 15 Oct 2014 16:09:05 GMT Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites http://gavinsoorma.com/2011/02/using-tune_mview-and-explain_rewrite-to-enable-us-to-tune-mv-fast-refreshes-and-query-rewrites/ Use 11g packages in DBMS_MVIEW to see how the SQL query transformed or rewritten to use materialized view instead Oracle > Optimization MondoTofu Mon, 22 Sep 2014 13:55:04 GMT Materialized Views: ON COMMIT http://www.sqlsnippets.com/en/topic-12894.html Oracle MondoTofu Tue, 13 Sep 2011 19:02:27 GMT