Operational Defect Database
BugZero found this defect 221 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2636294
Fixes an issue in which the cardinality estimation (CE) uniformly increases after each LEFT JOIN or RIGHT JOIN combines, which causes overestimation. This fix adds a limitation to the CE when the join predicates are the primary keys of the tables that are involved. Note: Trace flag 9440 will turn off the functionality provided by this fix for databases with a compatibility level of 160 and earlier.
Last update date:
10/12/2023
Affected products:
SQL Server 2022 on Linux
SQL Server 2022 on Windows
Affected releases:
build lower than 16.0.4085.2
Fixed releases:
16.0.4085.2
Description:
Fixes an issue in which the cardinality estimation (CE) uniformly increases after each LEFT JOIN or RIGHT JOIN combines, which causes overestimation. This fix adds a limitation to the CE when the join predicates are the primary keys of the tables that are involved. Note: Trace flag 9440 will turn off the functionality provided by this fix for databases with a compatibility level of 160 and earlier.
