Online Documentation for SQL Administrator for SQL Server

Spatial index options


Use the Spatial tab to set spatial index options. The settings on this tab are available only if the !RadioButton Spatial index was selected on the Properties tab.

Spatial indices are enabled in SQL Server 2008 and higher.

 

Index Editor - Spatial index options

 

 

Bounding box (for geometry data only)

Specifies a numeric four-tuple that defines the four coordinates of the bounding box: the x-min and y-min coordinates of the Lower-left corner, and the x-max and y-max coordinates of the Upper-right corner.

 

Grid tessellation

Define the density of the grid at each level of a tessellation scheme.

 

!RadioButton Automatic grid tessellation

Check this option to set default values for this data type.

 

Grid size of level n

 

!RadioButton Default

If the database compatibility level is set to 100 or lower, then the default is MEDIUM on all levels. When the database compatibility level is set to 110 or higher, then the default is an auto grid scheme.

 

!RadioButton Low (4x4)

Specifies the lowest possible density for the grid at a given level. LOW equates to 16 cells (a 4x4 grid).

 

!RadioButton Medium (8x8)

Specifies the medium density for the grid at a given level. MEDIUM equates to 64 cells (an 8x8 grid).

 

!RadioButton High (16x16)

Specifies the highest possible density for the grid at a given level. HIGH equates to 256 cells (a 16x16 grid).

 

Spatial options

 

Max cells per object (except level 1)

Set the number of tessellation cells per object that can be used for a single spatial object in the index by the tessellation process. If the !CheckBox Default option is checked then the default value is used for the specified tessellation.