2483204 - DB performance issue on orderhistoryentry ( adding index )

Symptom

Data feed imports for order & orderhistory entries are taking long to complete.

DB reporting tools are showiung that the following query is causing performance problem:

SELECT MAX( item_t0.p_orderpos )
FROM orderhistoryentries item_t0
WHERE ( item_t0.p_order =:1 )
AND (item_t0.TypePkString=:2 )

Also above sql can be found in jdbc logs:

|800|25%|152597|92%|191|17|SELECT MAX( item_t0.p_orderpos ) FROM orderhistoryentries item_t0 WHERE ( item_t0.p_order =?) AND (item_t0.TypePkString=? )|
Total count : 800
Total time : 152597ms
Average time : 191ms

Environment

Hybris 5.x

Hybris 6.x

Product

SAP Commerce Cloud 1808 ; SAP Commerce Cloud 1811 ; SAP Commerce Cloud 1905 ; SAP Commerce Cloud 2005 ; SAP Commerce Cloud 2011 ; SAP Commerce Cloud 2105 ; SAP Commerce Cloud 2205 ; SAP Commerce Cloud 2211 ; SAP Commerce Cloud 2211 for JDK21 ; SAP Commerce Cloud 6.7

Keywords

adding index orderhistoryentry orderhistoryentries , KBA , CEC-SCC-COM-BC-BCOM , Base Commerce , 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.