sp_help_spatial_geometry_index (Transact-SQL)

sp_help_spatial_geometry_index (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the names and values for a specified set of properties about a geometry spatial index. The result is returned in a table format. You can choose to return a core set of properties or all properties of the index.

Applies to: SQL Server (SQL Server 2012 through current version).

Topic link icon Transact-SQL Syntax Conventions

  
sp_help_spatial_geometry_index [ @tabname =] 'tabname'   
     [ , [ @indexname = ] 'indexname' ]   
     [ , [ @verboseoutput = ] 'verboseoutput'   
     [ , [ @query_sample = ] 'query_sample']   

See Arguments and Properties of Spatial Index Stored Procedures.

See Arguments and Properties of Spatial Index Stored Procedures.

User must be assigned a PUBLIC role to access the procedure. Requires READ ACCESS permission on the server and the object.

Properties containing NULL values are not included in the return set.

The following example uses sp_help_spatial_geometry_index to investigate the spatial index SIndx_SpatialTable_geometry_col2 defined on table geometry_col for the given query sample in @qs. This example returns only the core properties of the specified index.

declare @qs geometry  
        ='POLYGON((-90.0 -180.0, -90.0 180.0, 90.0 180.0, 90.0 -180.0, -90.0 -180.0))';  
exec sp_help_spatial_geometry_index 'geometry_col', 'SIndx_SpatialTable_geometry_col2', 0, @qs;  

Spatial Index Stored Procedures
sp_help_spatial_geometry_index_xml
Spatial Indexes Overview
Spatial Data (SQL Server)

Community Additions

ADD
Show:
© 2016 Microsoft