Working with Spatial Indexes (Database Engine)
SQL Server 2008 introduces support for spatial data and spatial indexes. A spatial index is a type of extended index that allows you to index a spatial column. A spatial column is a table column that contains data of a spatial data type, such as geometry or geography. The topics in this section introduce spatial indexing.
In This Section
Spatial Indexing Overview
Discusses tessellation as it is used by spatial indexes, including introducing the supported tessellation schemes and how they optimize the storage of information about spatial objects.Restrictions on Spatial Indexes
Describes restriction on spatial indexes.Creating, Modifying, and Dropping Spatial Indexes
Describes the restrictions on creating a spatial index and links to topics about how to create, alter, or drop a spatial index.Geometry Methods Supported by Spatial Indexes
Describes the conditions under which set-oriented geometry methods are supported by spatial indexes that use the geometry grid tessellation scheme.Geography Methods Supported by Spatial Indexes
Describes the conditions under which set-oriented geography methods are supported by spatial indexes that use the geography grid tessellation scheme.