3672572 - Fluctuating performance of statements related to ADR* tables: ADRCOMC, ADRT, ADRU, ADR2, ADR3, ADR6, ADRV

Symptom

The statement execution time fluctuates for statements using ADR* tables.

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	ELA_PER_REC_MS
\|==========	==========	=============	===	==============	==============	==============	=================	===============	==============
\|2025/10/24	host1	6666666	H	3283058	3857963	1.17	1158787	0.35	0.3
\|2025/10/23	host1	6666666	H	4629494	5615084	1.21	1955347	0.42	0.34
\|2025/10/22	host1	6666666	H	5298333	6397058	1.2	2124616	0.4	0.33
\|2025/10/21	host1	6666666	H	5425458	6588151	1.21	2000076	0.36	0.3
\|2025/10/20	host1	6666666	H	4379528	7006459	1.59	12393863	2.82	1.76
\|2025/10/20	host1	777	H	488940	586039	1.19	56644139	115.85	96.65
\|2025/10/19	host1	777	H	983995	1164496	1.18	118624520	120.55	101.86
\|2025/10/19	host1	55555	H	95458	135499	1.41	22173	0.23	0.16
\|2025/10/18	host1	55555	H	1835847	2216029	1.2	778117	0.42	0.35
\|2025/10/17	host1	55555	H	4549246	5423141	1.19	1956120	0.42	0.36
\|2025/10/16	host1	55555	H	4831289	5899605	1.22	2022878	0.41	0.34

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

Environment

SAP HANA.

Keywords

ADRCOMC, ADRT, ADRU, ADR2, ADR3, ADR6, ADRV, performance, delivery note,00364c15bee4eda3b700114e6eac5b64
0536f3e797bf197ef74742b38213f7cd
0734bb8360ee430834fd79e47c6c8ded
1597073bbcf6406954b6a9928d9c353d
16aeba53544d60ed5830381d18d01c72
1b0c5dd7d91a5b09dd77dea7ea661b65
1b7ab75efce9b7faa1cfe76055cdf27a
2277027b8cfeb569dd927370923742c1
28eca34e67703597f1adf03bd5182bda
3d12378e0bb47cad454a0a992533afa6
3e14b5fed3f9fbeffddb469170e07ca1
426e348da3b70020882d3881b7adc081
46657f53f01423f6764a3064cc43a0cf
46c2d08f694e349382de1f56c27a7793
4c0e6df6273996ccdd9783c348a3da89
5385e5a03dc37f05c5d95e8e9719a904
54a156ae830b695e5b9d3df5093948ba
577117dc8196ac60ed45db5b37f39a95
69c9dd739e14da09645891b9d241fb5f
7244ba52783c2daf358b520df7cc670a
8077c04a1ea6703b0c26c05f29bf3482
835d6a74a3354b843e1aba582c2b1150
8468aec357c3ddda63c0c852c0736e23
84d768b33354f0bcf82d25b8ceb9abe0
90da0c0c94022c89a288aa895287d36b
94c404d4671dc6a2a1a3edb43ebf3408
9e7fb318871ecff7c6f4962d4e218b92
b9222b17dda947f29917acf4743f6f91
b93fb8f6717b3e2f62423fb7fe14330e
bdb6de442e6e0f19385ee67e226fb831
be7fc33b798435d8d7e14007fc7125af
bf877ef00892a87b4e6cdd72f13c710b
c07285806fb3cbbc785c54a78deb44f3
c78c8ae851ff89d63816309dfed3f02f
c9418a6333cb3ee55259cc30e9305dbc
cba6a447f8e13058c0a2007c2da631e4
cf7670e9527c4fc1ea412f843e79ec1b
d0fa7c2e180e845e806068f4dca2a926
dae1ca689083de83b6e2bf3d10e9d90b
def6f6daced09645fa35497dc348ffe9
e094153a06fbbe726d8ea7ba55e87d0c
e7e2b348b9a2b59422d481f753320baa
f07de1b462bdff69190fc9667d279dde
f08c07ad0f068ff850e1d734b6a1cc94
f40afa9a4709cdfd912d6108cc8bc052
f587ec125bf2c2d90d9066afe1de6d2f
fe3c0dc3965e58c839f99efd034178eb
feb81cb341207491e87484809ca84c32 , KBA , HAN-DB-PERF , SAP HANA Database Performance , BC-SRV-ADR , Address Management / Business Address Services , 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.