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

Published Jan 15 2019 04:53 PM 177 Views
Microsoft
First published on MSDN on Mar 10, 2016

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

%3CLINGO-SUB%20id%3D%22lingo-sub-318698%22%20slang%3D%22en-US%22%3ESQL%202016%20-%20It%20Just%20Runs%20Faster%3A%20Spatial%20Index%20Builds%20Faster%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-318698%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Mar%2010%2C%202016%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EIndex%20creation%20and%20tessellation%20are%20often%20intensive%2C%20spatial%20activities.%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Along%20with%20the%20native%20and%20TVP%2C%20spatial%20enhancements%20additional%20work%20to%20optimize%20index%20creation%20and%20tessellation%20was%20completed.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3ETesting%20reveals%20that%20building%20a%20spatial%20index%20on%20SQL%20Server%202016%2C%20with%20the%20improved%20design%2C%20can%20be%20more%20than%202%20times%20faster%20than%20SQL%20Server%202012%20or%202014%20on%20the%20same%20data%20and%20hardware.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EIt%20has%20become%20common%20place%20for%20spatial%20tables%20to%20be%20300%20million%20or%20more%20rows%20and%20reduction%20of%20the%20index%20build%20time%20by%20a%20factor%20of%202x%20or%20more%20reduces%20maintenance%20window(s.)%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3E'It%20Just%20Runs%20Faster'%20%3C%2FSTRONG%3E%20-%20Apply%20SQL%20Server%202016%20and%20Spatial%20index%20building%20is%202%20or%20more%20times%20faster.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EBob%20Dorr%20-%20Principal%20SQL%20Server%20Escalation%20Engineer%3C%2FP%3E%0A%20%20%3CP%3EGreg%20Lapinski%20-%20Principal%20SQL%20Server%20Developer%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-318698%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Mar%2010%2C%202016%20Index%20creation%20and%20tessellation%20are%20often%20intensive%2C%20spatial%20activities.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-318698%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esql%202016%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 04:53 PM
Updated by: