Reg:materialized view query rewrite
hi
when i taken the explain plan of the MV,the output is like this
Elapsed: 00:00:00.04
SQL> select operation,object_name from plan_table;
OPERATION OBJECT_NAME
------------------------------ --------------------
SELECT STATEMENT
MAT_VIEW REWRITE ACCESS MV_BIGTAB
means the query rewite is happening
........
but when i checked the same thing using the dbms_mview.explain_rewrite
the output i got is..
SQL> select message from rewrite_table order by sequence;
MESSAGE
--------------------------------------------------------------------------------
QSM-01150: query did not rewrite
QSM-01263: query rewrite not possible when query references a dictionary table o
r view
it is saying the query did not rewirte...
i am new to MV and the query rewrite....
why it is showing like this
gopu