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

Symptom

You face performance degradation or fluctuation when running statements using ADR* tables. Example statement:

SELECT /* FDA READ */ "CLIENT" , "ADDRNUMBER" , "PERSNUMBER" , "COMM_TYPE" , "CONSNUMBER", "COMM_USAGE" , "VALID_TO" , "VALID_FROM" , "DEF_USAGE" , "ADRU_UUID" , "_DATAAGING" FROM "ADRU" WHERE "CLIENT" = ? AND "ADDRNUMBER" = ? AND "PERSNUMBER" = ?
You check a data collector for the affected statement hash and see similar result to this:

\|SNP_TIME	HOST	PLAN_ID	ENG	EXECUTIONS	RECORDS	REC_PER_EXEC	ELAPSED_MS	ELA_PER_EXEC_MS
\|==========	============	=============	===	==============	==============	==============	=================	===============
\|2025/11/18	hostname	29550111	H	567711	2155042	3.85	791813012	1392.78
\|2025/11/17	hostname	29550111	H	602192	237372	3.84	902655740	1492.5
\|2025/11/16	hostname	29550111	H	361455	877577	4.13	382125044	1582.59
\|2025/11/15	hostname	29550111	H	78869	317884	4	14593434	186.38
\|2025/11/14	hostname	400690222	H	219808	396484	3.41	48212	0.43
\|2025/11/13	hostname	400690222	H	126415	758956	3.24	31317	0.21
\|2025/11/12	hostname	400690222	H	250030	950829	3.65	61297	0.23
\|2025/11/11	hostname	400690222	H	274445	965452	3.32	58851	0.21

Sometimes a bad plan is used and so the execution time (column: ELA_PER_EXEC_MS) is significantly higher.

Environment

SAP HANA.

Keywords

tables starting ADR, 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.