Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Query rewrite in Oracle 12c

RudiJan 17 2018 — edited Mar 27 2018

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 24 2018
Added on Jan 17 2018
#data-warehousing, #olap
2 comments
1,018 views