A spatial index can be created only on a column of type geometry or geography.
Spatial indexes can be defined only on a table that has a primary key. The maximum number of primary key columns on the table is 15.
The maximum size of index key records is 895 bytes. Larger sizes raise an error.
 Note |
|---|
Primary key metadata cannot be changed while a spatial index is defined on a table. |
Spatial Indexes cannot be specified on indexed views.
You can create up to 249 spatial indexes on any of the spatial columns in a supported table. Creating more than one spatial index on the same spatial column can be useful, for example, to index different tessellation parameters in a single column.
You can create only one spatial index at a time. For more information, see CREATE SPATIAL INDEX (Transact-SQL) or How to: Create a Spatial Index (SQL Server Management Studio).
An index build cannot make use of available process parallelism.