Category: advanced tech
how to study oracle and some useful habits
最近做的一次内部交流文档[……]
Optimizer in Oracle 11g by wwf.
By wwf from ebay COC about Optimizer in Oracle 11g.
[……]
Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites
We can use the DBMS_MVIEW.EXPLAIN_REWRITE package (which was first introduced in Oracle 9i if memory serves me right) to diagnose why Query redirectio[……]