Influencing the SQL Optimizer in SaaS ERP Applications
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.
Tagged:
1