In my previous article Faster query execution with lesser memory now also available in SAP HANA Platform SPS07, I had explained how a performance can drop when an existing HEX execution reaches a threshold limit and the plan gets recompiled to one of the older engines and cached called fallback. This is to protect the system from possible regressions caused by the new HEX features using threshold limits. The issue is that the newly cached plan may not be optimal for most of the executions times and thus the performance drop is noticed.
The auto-recompilation can be configured to detect such occurrences and possibly recover from the fallback.
In my previous article Faster query execution with lesser memory now also available in SAP HANA Platform SPS07, I had explained how a performance can drop when an existing HEX execution reaches a threshold limit and the plan gets recompiled to one of the older engines and cached called fallback. This is to protect the system from possible regressions caused by the new HEX features using threshold limits. The issue is that the newly cached plan may not be optimal for most of the executions times and thus the performance drop is noticed.The auto-recompilation can be configured to detect such occurrences and possibly recover from the fallback. Read More Technology Blog Posts by SAP articles
#SAP
#SAPTechnologyblog
perfectly!