Try our conversational search powered by Generative AI!

Review of indexes on CatalogItemAsset and ecfVersionAsset

Found in

EPiServer.Commerce 12.0.0

Fixed in

EPiServer.Commerce 13.7.1

(Or a related package)

Created

Aug 28, 2019

Updated

Sep 11, 2019

Area

Core

State

Closed, Fixed and tested


Description

  • ecfVersionAsset non clustered index IDX_ecfVersionAsset_WorkId can be removed as it is already covered by the clustered index.
  • CatalogItemAsset clustered index should changed to be CatalogEntryId first, as it's expected to have better cardinality, and that would make the non clustered index IX_CatalogItemAsset_EntryId obsolete.
  • IX_CatalogItemAsset_NodeId should include GroupName and SortOrder, so it no longer needs to do key look up.