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.
 Note |
|---|
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
How to: Create a Spatial Index (SQL Server Management Studio)
How to: Configure the index create memory Option (SQL Server Management Studio)
To view information about an index
To alter a spatial index
- Important
To change options that are specific to a spatial index, such as BOUNDING_BOX or GRID, you can either use a CREATE SPATIAL INDEX statement that specifies DROP_EXISTING = ON, or drop the spatial index and create a new one. For an example, see CREATE SPATIAL INDEX (Transact-SQL).
How to: Move an Existing Index to a Different Filegroup (SQL Server Management Studio)
To drop a spatial index
