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