http://www.netvouz.com/MondoTofu/tag/explain_rewrite?feed=rss MondoTofu's bookmarks tagged "explain_rewrite" on Netvouz 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