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 , SAP Commerce , CEC-COM-CPS-COR , SAP Commerce Core , 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.