Missing index for stored procedure netContentChildrenReferences

Fixed in

EPiServer.CMS.Core 11.20.7

(Or a related package)

Created

May 18, 2020

Updated

Jun 16, 2021

Area

CMS Core

State

Closed, Fixed and tested

Description

Introduce an index that will help this highly utilized stored procedure that backs one of the provider calls to .GetChildren(). Adding this index will bring each of the branches down Logical IOs by 98+% on tblContent.