/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
SAP recommends to implement statement hints in order to avoid performance issues or high resource consumption due to wrong optimizer decisions.
Change history:
| Date | Change |
| 2026/03/10 |
STXH hashes 1d55b692252bc3ce2f5d1721b022168e, 3bfcf18dff878c9b1be1dda6ddf881ee, bb18727b03b80904dd8bd21f5fec0d3e, f06917f833a9e46faffeb3b77c4b5c9d added |
| 2026/01/28 |
Table P_EWM_WHSEREQOUT_MIGSTATUS_SDM added |
| 2025/12/08 |
STXH hashes 2cd130a15f96a357a7d327c95aad8836, 9c5411aeed36d1b4e1d9202256a544cd, d444388b8308147fc383d1411aabaa91, 32263a543955c9417c005a40b91caab2 added |
| 2025/11/18 |
ADR* statement hints removed for SAP HANA >= 2.0 SPS 08 (SAP Note 3513868) |
| 2025/08/29 |
VBKD added for SAP HANA >= 2.0 SPS 08 |
| 2025/07/16 |
STXH hashes 05a97129d0423f7be8df768d43a5315c, 04f5ae7626ca31d30a80c6f9bc8a1fed, 56fb56c5b5e26b468c443ea4fcc753ea, fa761f71c24bb95570ed769eedb02c8e, 697ee3facf1042240cc11332fb155750, 42f698f2feb195eb00f5006d165e7962, ac62ff5bd6ee687c2b4ff3ded15ca13d, fcad3b3f37c0ea4486f3f9ad527a76b5 added |
| 2025/05/28 |
ADRCOMC added |
| 2025/05/25 |
STXH hashes 66fe5243d70945407cd1fbc1f5432468, bc022f0a7c114acb582fb84aacfdb4c6, 2a06257236451c43dd1e543081f003d4, 9ba05764a7fd4727fa07225e0f78cd79, 7ae80b63120b758e2830bff32ed06ca0, 40f678fed9e4bb8ad148c48c6ab869c9, 55fdbef426d59a0d0987ce304e367f38, 2fe0b8c6cfa9a2e88161ea1136c45ed0 added Automatic removal of existing plans with /* FDA READ */ comments with creation commands for SAP HANA >= 2.0 SPS 06 |
| 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
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.
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)