Designing and Implementing Spatial Storage How-to Topics
SQL Server 2008 R2
Spatial indexes improve the efficiency of certain set-oriented operations on spatial objects. A spatial index reduces the number of objects on which relatively costly spatial operations need to be applied.
