Spatial Index Stored Procedures (Transact-SQL)

SQL Server supports the following system stored procedures that are used to analyze and improve the indexing performance of spatial indexes. 

sp_help_spatial_geometry_index	sp_help_spatial_geography_index
sp_help_spatial_geometry_index_xml	sp_help_spatial_geography_index_xml

SQL Server supports the following system stored procedures to help pick the correct spatial index parameters.

sp_help_spatial_geography_histogram (Transact-SQL)

sp_help_spatial_geometry_histogram (Transact-SQL)

See Also

Concepts

Spatial Data (SQL Server)

Spatial Indexes Overview