Troubleshooting SQL Server Spatial Query Performance: A Deep Dive into Spatial Indexing

Play Troubleshooting SQL Server Spatial Query Performance: A Deep Dive into Spatial Indexing
Sign in to queue

Description

Spatial data operations are often expensive. Thus, in order to achieve the required performance and scalability in spatial database applications, we need to define spatial indices. This presentation describes how Microsoft SQL Server 2008 and 2012 spatial indexes work and gives tips and presents the tools on how to analyze and improve your spatial application's performance even when it needs to scale to large amounts of spatial data. The session assumes a core understanding of the spatial functionality in SQL Server 2008 or later. #TEDBI405

Embed

Download

The Discussion

Add Your 2 Cents