How to Create Spatial Indexing

You can create a spatial index.

Spatial indexes are used by spatial databases to optimize spatial queries. Indexes used by spatial databases provide the ability to determine results such as; how far two points differ and whether points are located within a certain region.

Instructions

1. Open "Microsoft SQL Server." Select the "SQL Server Management Studio" tool. Select the "Object Explorer" option, then connect to the desired instance of the SQL Server Database Engine. Expand the desired "Connection" instance.

2. Select the "Expand Databases" option then expand the database that contains the table with the desired index.

3. Select the "Expand Tables" option then expand the table where you want to create the index.

4. Right-click the "Indexes" option. Select the "New Index" option. Enter a "Name" for the index in the index name field. Select the "Spatial" option from the index type dropdown list. Click "Add" to specify the spatial column that you want to index.

5. Select the desired column type "Geometry or Geography" by clicking the corresponding check box, in the select columns from table name, dialog box. Click "OK."

6. Verify the "Column Selection" in the index key columns grid.

7. Click "Spatial," in the Select a Page pane of the Index Properties, dialog box. This action will display the Spatial Page window.

8. Specify the values that you want to use for the spatial properties for the index.

9. Click the "OK" icon.

References

• Microsoft: Working with Spatial Indexes (Database Engine)