Hi
We have an issue regarding Oracle 12.1.0.2 query rewrite.
All the queries are generated by OBIEE 12c which heavily uses WITH Clauses a.k.a Subquery Factoring.
However, we see that even if we create MV which are full sql text match,the query rewrite doesn't happen.
We are using dbms_mview.explain_rewrite,in order to understand the root cause, but we get nowhere.
Any ideas/experience?
Thanks,
Rudi