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
2025/01/17

FKKDIPOTMP hashes 15a57c95913b86e6eeac034addc7a48c, fbb83898141f2f33d86725785915fc25, de6b3906f59796ff3192b51f631905c4, cb3e7321fc94e1ba375d6595622f4026 added
2024/11/30

NAST hashes d918985d5f15b886ce0b82e10fbf3243, b0101e8a31307c6f509cbc726e348f21, 54c080dd251a046a06e2641ff2cb9da8, 28a81c5e4deeaadfac5aebf0a24d26b6, e46b50ff293f9bc624293af592af80b1, 239985e53e6238f61141da5e9e694f32, baf38fec735db85754081db918a22922, e1e746510efab6b3c433909529143774 added
2024/11/21

dedicated 2.00.080+ version
2024/10/10

STXH hashes c0a29931b90fec21bc2068a8bce1183d, b42f76950ed88307329a78ca3bbf5620, 2ed7d48e4a9af82a0be336e1dd5f0d47, 093f81a4960e31871a1f6e448483e15e, bc1342f1e39a60afbddb0a17c5c83cef, b0fcbee2d05a577dadc5702318a458b4, ae381fd5ba6acc6f61e96be0fef350de, 89797bd5430b37d2a5b0a2618517e8d5 added
2024/10/09

STXH hashes a475c18cf7a1f2ac01bee618a672cbaf, a450774b850a7c0e4e0b0af55143e1b1, 28756aa9451659c348e122f5c5c2e2e9, d387622f72348f72bbbe2112e2e73d8c added
2024/10/08

DEV_HEX_INDEX_LOOKUP hints included for STX*, ADR* and TOA0* tables and SAP HANA >= 2.0 SPS 06
2024/09/30

STXL hashes 513225a2f19eb2bb43d150ff85372f0f, 19354e7e67213d6212f0df81da4b2d9e, b9f6cd78532283a78ef9a8efea5aedc1, 4c55cc3d1e447087df33bb57328e75f7, ac02ddd413034029702c97afb3fc19be, 97a49ffc74874c3c6062738d75156e72, 6f7a50eedb5601e59bf9dc59aaaf2a28, 8aee14a7ffb08fdf88d2759592b1b07a added
2024/09/21

STXH hashes c2ba78991cf102d23895f37013f414c0, e472acb667ca8bcc421c1eef917252ec, 9807a4101b41a305ae7e32d3604a3062, c81bfaaa2120b5efd4686b9a1d0d5180 added
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.