Try our conversational search powered by Generative AI!

Performance on Clustered index "IX_CatalogItemAsset_NodeId"

Found in

EPiServer.Commerce 13.21.0

Fixed in

EPiServer.Commerce 13.22.0

(Or a related package)

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.