KB5008107 - Improvement: Cardinality estimation in Spatial TVF functions in SQL Server 2019

Applies To
SQL Server 2019 on Linux SQL Server 2019 on Windows

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.