Index on CatalogItemAsset is inefficient

Fixed in

EPiServer.Commerce 13.19.0

Created

Apr 17, 2020

Updated

Jul 10, 2020

Area

Core

State

Closed, Fixed and tested


Description

CatalogItemAsset has both CatalogNodeId and CatalogEntryId, which are indexed. However as most of the rows, CatalogNodeId is 0, making any query filter by CatalogNodeId highly ineffective.