Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

NoteNote

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.