Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Influencing the SQL Optimizer in SaaS ERP Applications — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Influencing the SQL Optimizer in SaaS ERP Applications

Received Response
25
Views
4
Comments
edited Feb 4, 2021 8:19AM in Reporting and Analytics for ERP 4 comments

Summary

We have a query that was running perfectly in our non-prod environment for month up until mid December 2020. Then it suddenly timed out and performs poorly.

Content

We have the attached SQL running perfectly in our test environment from March last year up until mid December.  Suddenly it stopped working and was timing out when run from the BI Publisher data model.  It is designed to pick up only incremental data and with the date we passed, we aren't expecting a lot of records to be picked up, yet it is still timing out.  We are confused as to why this would happen for some unknown reason.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!