That means query rewrite is not happening ?
but here it shows that it is happening...why it is showing like that ?
SQL> select operation,object_name from plan_table;
OPERATION OBJECT_NAME
------------------------------ --------------------
SELECT STATEMENT
MAT_VIEW REWRITE ACCESS MV_BIGTAB




Reply With Quote