Review of indexes on CatalogItemAsset and ecfVersionAsset
Found in
EPiServer.Commerce 12.0.0
Fixed in
EPiServer.Commerce 13.7.1
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.