Try our conversational search powered by Generative AI!

Index on CatalogItemAsset is inefficient

Fixed in

EPiServer.Commerce 13.19.0

(Or a related package)

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.