Blog Post

SQL Server Blog
1 MIN READ

SQL 2016 – It Just Runs Faster: Spatial Index Builds Faster

BobDorr's avatar
BobDorr
Icon for Microsoft rankMicrosoft
Feb 28, 2022
Moved from: bobsql.com

 

Index creation and tessellation are often intensive, spatial activities.    Along with the native and TVP, spatial enhancements additional work to optimize index creation and tessellation was completed.

 

Testing reveals that building a spatial index on SQL Server 2016, with the improved design, can be more than 2 times faster than SQL Server 2012 or 2014 on the same data and hardware. 

 

It has become common place for spatial tables to be 300 million or more rows and reduction of the index build time by a factor of 2x or more reduces maintenance window(s.)

 

‘It Just Runs Faster’ – Apply SQL Server 2016 and Spatial index building is 2 or more times faster.

Updated Feb 28, 2022
Version 1.0
No CommentsBe the first to comment