This topic has not yet been rated - Rate this topic

Working with Spatial Indexes (Database Engine)

SQL Server 2008

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.

Other Resources

Working with Spatial Data (Database Engine)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD