Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

E. Pollack, J. StrateExpert Performance Indexing in Azure SQL and SQL Server 2022https://doi.org/10.1007/978-1-4842-9215-0_7

7. Spatial Indexing

Edward Pollack¹   and Jason Strate²

(1)

Albany, NY, USA

(2)

Hugo, MN, USA

 

Spatial data types advance the storage capabilities of SQL Server, allowing data that defines shape and location information. Before these enhancements, spatial data was often stored as string or numeric values without implicit meaning within the database. This required cumbersome conversions and calculations to resolve the information into meaningful insights.

As part of spatial data support, SQL Server introduced the GEOMETRY and GEOGRAPHY data ...