Operational Defect Database
BugZero found this defect 910 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 14309095
KB5008107 - Improvement: Cardinality estimation in Spatial TVF functions in SQL Server 2019 - Microsoft Support
Last update date:
11/22/2021
Affected products:
SQL Server 2019 on Linux
SQL Server 2019 on Windows
Affected releases:
build lower than 15.0.4188.2
Fixed releases:
15.0.4188.2
Description:
Improvement
This improvement introduces dynamic cardinality estimation for spatial tessellation functions that are used together with GEOMETRY_AUTO_GRID and GEOGRAPHY_AUTO_GRID spatial indexes. This feature helps the query optimizer produce better plans and improves the lock escalation experience.
Resolution
Cumulative update information This improvement is included in the following cumulative update for SQL Server: Cumulative Update 14 for SQL Server 2019 About cumulative updates for SQL Server Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server: Latest cumulative update for SQL Server 2019
References
Learn about the terminology that Microsoft uses to describe software updates.
