3674286 - Fluctuating performance of statements related to NAST table

Symptom

NAST table related statements, e.g.

SELECT * FROM "NAST" WHERE "MANDT" = ? AND "KAPPL" = ? AND "OBJKY" BETWEEN ? AND ?;

perform fluctuating.

You check a data collector result and see similar to this:

\|SNP_TIME	HOST	PLAN_ID	ENG	EXECUTIONS	RECORDS	REC_PER_EXEC	ELAPSED_MS	ELA_PER_EXEC_MS
\|==========	============	=============	===	==============	==============	==============	=================	===============
\|2025/10/10	hostname	7864524999	H	467711	155042	3.85	791813012	1001.4
\|2025/10/09	hostname	7864524999	H	302192	239872	3.84	902655740	758.2
\|2025/10/08	hostname	7864524999	H	661455	777547	4.13	382125044	867.88
\|2025/10/07	hostname	7864524999	H	78669	427868	4	14593434	300.08
\|2025/10/06	hostname	568489777	H	310008	546684	3.41	48212	1.99
\|2025/10/05	hostname	568489777	H	420515	658946	3.24	31317	2.5
\|2025/10/04	hostname	568489777	H	650880	856622	3.65	61297	2.53
\|2025/10/03	hostname	568489777	H	355445	864460	3.32	58851	2.51

Sometimes a bad plan is used and so the execution time is higher.

Environment

SAP HANA.

Keywords

NAST, performance, 239985e53e6238f61141da5e9e694f32
28a81c5e4deeaadfac5aebf0a24d26b6
54c080dd251a046a06e2641ff2cb9da8
b0101e8a31307c6f509cbc726e348f21
baf38fec735db85754081db918a22922
d918985d5f15b886ce0b82e10fbf3243
e1e746510efab6b3c433909529143774
e46b50ff293f9bc624293af592af80b1 , KBA , HAN-DB-PERF , SAP HANA Database Performance , Known Error

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.