Index Properties (Spatial Page)
When you are creating a spatial index, use the Spatial page of the New Index dialog box to specify the values of the spatial properties.
For an existing spatial index, use the Spatial page of the Index Properties dialog box to view or modify the spatial properties of the index. When you modify any of the spatial properties, the spatial index is dropped and re-created.
When you are creating a spatial index, you can generate the Transact-SQLCREATE SPATIAL INDEX script for creating the spatial index by clicking the Script button and then selecting a destination for the script.
To create a spatial index in SQL Server Management Studio
To view the properties of an index in SQL Server Management Studio
The bounding box is the perimeter of the top-level grid of a geometric plane. The bounding-box parameters exist only in the geometry grid tessellation. These parameters are dimmed if the Tessellation Scheme is Geography grid.
The panel displays the (X-min,Y-min) and (X-max,Y-max) coordinates of the bounding box. There are no default coordinate values. Therefore, when you are creating a new spatial index on a geometry type column, you must specify the coordinate values.
This panel shows the density of the grid at each level of the tessellation scheme. Density is specified as Low, Medium, or High. The default is Medium. Low represents a 4x4 grid (16 cells), Medium represents an 8x8 grid (64 cells), and High represents a 16x16 grid (256 cells).