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
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.