Try our conversational search powered by Generative AI!

Slow queries when using function fn_UriSegmentExistsOnSiblingNodeOrEntry

Fixed in

EPiServer.Commerce 13.25.0

(Or a related package)

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.