sql-server - SQL 2019 上的 CU6 到 CU 11 升级使对表格函数的查询非常慢

Question

从 SQL server 2019 CU6 升级到 CU11 后：下面标有 --Slow running 查询突然变慢的查询。CD_TF() 包含对另一个 TF 的 OUTER APPLY。

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;

--Slow running query 
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)  

标签： sql-serversql-server-2019