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.0BobDorr
Microsoft
Joined January 13, 2022
SQL Server Blog
Follow this blog board to get notified when there's new activity