On the Spatial page, specify the values that you want to use for the spatial properties of the index. In the Select a page pane of the Index Properties dialog box, click Spatial. Verify your column selection in the Index key columns grid. If you want to select a different spatial column, you must first clear the currently selected column. Any other spatial columns then become uneditable. In the Select Columns from dialog box, select a column of type geometry or geography by selecting the corresponding check box. To specify the spatial column that you want to index, click Add. In the Index type drop-down list, select Spatial. In the Index name field, enter a name for the index. Right-click Indexes and select New Index. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.Įxpand Databases, expand the database that contains the table with the specified index, and then expand Tables.Įxpand the table for which you want to create the index.

To create a spatial index by using the New Index dialog box in Management Studio To create a spatial index in Management Studio To create a spatial index by using Transact-SQL Creating, Modifying, and Dropping Spatial Indexes To create a spatial index For information about the relationship of spatial indexes to partition and to filegroups, see the 'Remarks' section in CREATE SPATIAL INDEX (Transact-SQL).

Geography grids