Symptom
You want to implement statement hints in order to avoid performance issues or high resource consumption due to wrong optimizer decisions.
Change history:
Date | Change |
2020/12/07 |
IGNORE_PLAN_CACHE, OPTIMIZATION_LEVEL(RULE_BASED) for ST-A/PI mini check execution removed (execution centrally deactivated) |
2020/10/05 |
IGNORE_PLAN_CACHE, OPTIMIZATION_LEVEL(RULE_BASED) for ST-A/PI mini check execution added |
2020/08/18 |
HEX_HASH_JOIN for EDIDS accesses with subquery added |
2020/07/07 | TRFCQOUT statements with QNAME / DEST / QCOUNT added |
2020/06/24 | ODQDATA added |
2020/05/14 | OPTIMIZATION_LEVEL(RULE_BASED) hint added for TRFCQIN |
2020/03/31 | TRFCQOUT statement with hash e4ee5310d59f1a949294663ec9901639 added |
2020/03/03 | further TRFCQOUT statements added (with RANGE_RESTRICTION clause) |
2019/11/04 | TRFCQIN added |
2019/10/03 | TBTCO added |
2019/07/09 | further STXH statements added |
2019/05/07 | TRFCQOUT (LIKE on QNAME) added |
2019/04/09 | EDIDS added |
2019/04/04 | STXH added |
2019/03/14 | TRFCQOUT added |
Read more...
Environment
SAP HANA
Product
SAP HANA, platform edition all versions
Keywords
Expensive SQL statements optimizer statement hints delivery , KBA , HAN-DB , SAP HANA Database , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.