3089581 - Query perform issue caused by the improper column definition.

Symptom

Found most of DTU cost by the query in the below, DTU utilization almost keeping at 100%.

(@P0 nvarchar(4000),@P1 bigint,@P2 nvarchar(4000),@P3 bigint,@P4 nvarchar(4000),@P5 bigint,@P6 nvarchar(4000),@P7 bigint,@P8 nvarchar(4000),@P9 bigint,@P10 nvarchar(4000),@P11 bigint)
SELECT item_t0.PK FROM order1 item_t0
WHERE
( item_t0.p_orderno =@P0)
AND (item_t0.TypePkString=@P1 )
UNION ALL SELECT item_t0.PK FROM order2 item_t0
WHERE ( item_t0.p_orderno =@P2)
AND (item_t0.TypePkString=@P3 )
UNION ALL SELECT item_t0.PK FROM order3 item_t0
WHERE ( item_t0.p_orderno =@P4) AND (item_t0.TypePkString=@P5 )
UNION ALL SELECT item_t0.PK FROM otherorder item_t0
WHERE ( item_t0.p_orderno =@P6) AND (item_t0.TypePkString=@P7 )
UNION ALL SELECT item_t0.PK FROM order4 item_t0
WHERE ( item_t0.p_orderno =@P8)
AND (item_t0.TypePkString=@P9 )
UNION ALL SELECT item_t0.PK FROM order5 item_t0
WHERE ( item_t0.p_orderno =@P10)
AND (item_t0.TypePkString=@P11 )

Here is the execution detail checked in Azure portal:

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Commerce Cloud

Product

SAP Commerce Cloud all versions

Keywords

query performance , KBA , CEC-SCC-PLA-PL , Platform , Problem

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.