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.
Bob Dorr – Principal SQL Server Escalation Engineer
Greg Lapinski – Principal SQL Server Developer