Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

AI OnAI Off

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.