DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops

Create, Modify, & Drop Spatial Indexes

A spatial index can more efficiently perform certain operations on a column of the

or

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

in this topic.

CREATE SPATIAL INDEX (Transact-SQL)

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine and then

expand that instance.

  1. Expand

, expand the database that contains the table with the specified index,

and then expand.

  1. Expand the table for which you want to create the index.

  2. Right-click

and select.

  1. In the

field, enter a name for the index.

  1. In the

drop-down list, select.

７

Note

For information about the relationship of spatial indexes to partition and to filegroups, see

the “Remarks” section in.

To create a spatial index in Management Studio