Export (0) Print
Expand All

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft