Hi Experts,
Query rewrite option is not working.
I have created the following materialized view with "enable query rewrite option".
ALTER SESSION SET QUERY_REWRITE_ENABLED = TRUE;
create materialized VIEW mv12
REFRESH COMPLETE ON demand
enable query rewrite
as
select d.deptno,sum(e.sal) from emp e,dept d
where e.deptno=d.deptno
GROUP BY d.deptno;
The query is using tables instead of MVIEW. Could you please help me.
Why it'snot using MVIEW.
select d.deptno,sum(e.sal) from emp e,dept d
where e.deptno=d.deptno
and d.deptno=10
GROUP BY d.deptno;
Thanks in advance.