Performance improvement for Spatial Internal Filter in SQL Server 2017

Applies to: 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.


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

       Cumulative Update 2 for SQL Server 2017


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


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