SAP Knowledge Base Article - Preview

2700051 - Delivery of Statement Hints (SAP HANA >= 1.00.122.03)

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
2024/05/01

Adjusted hints for STXH, ADR* and TOA0* tables, dedicated statement version for SAP HANA >= 2.0 SPS 06
2024/04/04

ADRT, ADRU, ADR2, ADR3, ADR6 added
2024/03/18

STXH / STXL hints extended with CS_FILTER_FIRST, statement hash ae7aae037f999685d55908000713b22d added, tables TOA01, TOA02 and TOA03 added
2022/10/08

TRFCQOUT statement hashes 46f7ed701af8e271a94a592944aeeda5 and b19b5145b99c58559e1678a39b4211c4 added
2022/08/13

TRFCQOUT statement hashes fa4b1ed668d15956ce86d56f3632a4d9, f053abebad183def228db1b506d49307 added
2022/06/09

various "WITH RANGE_RESTRICTION('CURRENT')" variants added
2022/05/23

EDIDS statement hash 30cc2a2936e36a3caa732accea1fa711 added
2022/05/06

further STXH queries added
2022/02/17

TRFCQOUT statement hash 4cc734c0928b50441befd3782e52ca71 added
2022/01/10

STXL added
2021/06/10

TRFCQOUT statement with hash c67e0ff151ad6c6de696a4b15f9d0c64 added
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 for Me (Login required).

Search for additional results

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