2483204 - DB performance issue on orderhistoryentry ( adding index )

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

Hybris 5.x

Hybris 6.x

adding index orderhistoryentry orderhistoryentries , KBA , CEC-SCC-COM-BC-BCOM , Base Commerce , Problem