Performance improvement for Spatial Internal Filter in SQL Server 2017

S’applique à : SQL Server 2017 on Windows (all editions)

Spatial internal filter performs a series of formal checks on a subset of rows recognized as positives by spatial primary filter. These checks used to take a significant portion of total execution time for some classes of spatial queries and spatial data sets.

This fix optimizes checks and minimizes their contribution in total query execution time.

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 2 for SQL Server 2017

Status


Microsoft has confirmed that this is an improvement for the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.