Creating, Modifying, and Dropping Spatial Indexes

A spatial index can more efficiently perform certain operations on a column of the geometry or geography data type (a spatial column). More than one spatial index can be specified on a spatial column. This is useful, for example, for indexing different tessellation parameters in a single column.

There are a number of restrictions on creating spatial indexes. For more information, see Restrictions on Spatial Indexes.


For information about the relationship of spatial indexes to partition and to filegroups, see the "Remarks" section in CREATE SPATIAL INDEX (Transact-SQL).

To create a spatial index

To view information about an index

To alter a spatial index

To drop a spatial index

See Also