3571947 - The reason for a statement invalidation / recompilation

Symptom

The query’s execution time is changed, the customer wants to know whether the execution plan has been changed.

In the results of HANA_SQL_StatementHash_DataCollector_ SQL statement, you can see the execution time is changed.

| SNP_TIME HOST PLAN_ID ENG EXECUTIONS RECORDS REC_PER_EXEC ELAPSED_MS ELA_PER_EXEC_MS ELA_PER_REC_MS PREPARES PREPARE_MS LOCK_MS |
| ========== ============ ============= ==== ============== ============== ============== ================= =============== ============== =========== ============== ============== |
| 2025/01/12 <host_name> 151550003 C 4502930 4513906 1.00 11436300 2.53 2.53 0 0 0 |
| 2025/01/11 <host_name> 21266980003 C 3447371 3475921 1.00 37790345 10.96 10.87 0 0 0 |

Environment

Starting with SAP HANA 1.00.122.17 and 2.00.020

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

"recompilations", "LAST_INVALIDATION_REASON", "2124112" , KBA , HAN-DB-PERF , SAP HANA Database Performance , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.