Performance on Clustered index "IX_CatalogItemAsset_NodeId"

Found in

EPiServer.Commerce 13.21.0

Fixed in

EPiServer.Commerce 13.22.0

Created

Jul 10, 2020

Updated

Jul 22, 2020

Area

Core

State

Closed, Fixed and tested


Description

The following Query causes the performance issue:
SELECT A.* from [CatalogItemAsset] A WHERE A.CatalogNodeId = @CatalogNodeId
when trying to manipulate with large campaigns.