SAP Knowledge Base Article - Preview

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


Read more...

Environment

Hybris 5.x

Hybris 6.x

Keywords

adding index orderhistoryentry orderhistoryentries , KBA , CEC-COM-CPS , Commerce Platform & Suite (SAP Commerce) , CEC-COM-CPS-COR , CPS Core (SAP Commerce) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.