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