What's new in Customer Journeys?

Connect and learn more!
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
edited Feb 4, 2021 8:19AM in Reporting and Analytics for ERP 4 comments


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.


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.


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