Slow queries on CatalogItemSeo table

Fixed in

EPiServer.Commerce 13.20.0

Created

May 27, 2020

Updated

Sep 10, 2020

Area

Core

State

Closed, Fixed and tested


Description

Several queries on CatalogItemSeo query Uri and UriSegment with LOWER() which makes the indexes non-performant.