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