Slow queries when using function fn_UriSegmentExistsOnSiblingNodeOrEntry

Fixed in

EPiServer.Commerce 13.25.0

Created

Sep 10, 2020

Updated

Nov 05, 2020

State

Closed, Fixed and tested


Description

Several queries when using function fn_UriSegmentExistsOnSiblingNodeOrEntry with LOWER() which makes the indexes non-performant.