How to: Create Spatial Indexes

You can use spatial indexes on columns of the geometry or geography data type (spatial columns), which you cannot index by using the Index/Keys dialog box. You can create more than one spatial index for each spatial column, but you must create them one at a time. For more information, see Spatial Indexing Overview and Restrictions on Spatial Indexes on the Microsoft Web site.

To create a spatial index

  1. In Server Explorer, click the database table that contains the column for which you want to create the index.

  2. On the Database menu, click Open Table Definition.

    The table opens in Table Designer.

  3. Click a column of the geometry or geography data type.

  4. On the Table Designer menu, click Spatial Index.

  5. In the Spatial Indexes dialog box, click Add.

  6. In the Selected Spatial Index list, click the index that you want to create.

  7. In the properties grid, set the properties for the spatial index. For more information, see Spatial Indexes Dialog Box.

See Also


How to: Create Tables

How to: Delete Spatial Indexes

How to: Open Table Designer

Other Resources

Working with Indexes