After upgrading from SQL server 2019 CU6 to CU11: below query marked with --Slow running query is slow suddenly. CD_TF() contains OUTER APPLY to another TF.
IF(OBJECT_ID('tempdb..#BrowseList1') IS NOT NULL)
DROP TABLE #BrowseList1
CREATE TABLE #BrowseList1
(
RowNumber dbo.ecm_RowNumber_DT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED
,OrderId dbo.ecm_OrderId_DT
,OrderGroupId dbo.ecm_OrderGroupId_DT
,InterfaceId dbo.ecm_InterfaceId_DT
);
INSERT INTO #BrowseList1(OrderId,OrderGroupId,InterfaceId)
SELECT OrderId,OrderGroupId,InterfaceId FROM AB_TF()
WHERE ( HolderId = N'1' ) ORDER BY OrderGroupId ASC;
SELECT o.*
FROM CD_TF() AS o
INNER JOIN
#BrowseList1 AS browser ON (o.OrderId = browser.OrderId AND o.OrderGroupId = browser.OrderGroupId AND o.InterfaceId = browser.InterfaceId)