sp_help_spatial_geography_index (Transact-SQL)
Applies to: SQL Server
Returns the names and values for a specified set of properties about a geography 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.
Transact-SQL syntax conventions
Syntax
sp_help_spatial_geography_index [ @tabname =] 'tabname'
[ , [ @indexname = ] 'indexname' ]
[ , [ @verboseoutput = ] 'verboseoutput' ]
[ , [ @query_sample = ] 'query_sample' ]
Arguments
See Arguments and Properties of Spatial Index Stored Procedures.
Properties
See Arguments and Properties of Spatial Index Stored Procedures.
Permissions
User must be assigned a PUBLIC role to access the procedure. Requires READ ACCESS permission on the server and the object.
Remarks
Example
The following example uses sp_help_spatial_geography_index
to investigate the geography spatial index SIndx_SpatialTable_geography_col2 defined on table geography_col for the given query sample in @qs. This example returns only the core properties of the specified index.
declare @qs geography
='POLYGON((-90.0 -180, -90 180.0, 90 180.0, 90 -180, -90 -180.0))';
exec sp_help_spatial_geography_index 'geography_col', 'SIndx_SpatialTable_geography_col2', 0, @qs;
The bounding box of a geography instance is the whole earth.
Requirements
See Also
Spatial Index Stored Procedures
sp_help_spatial_geography_index
Spatial Indexes Overview
Spatial Data (SQL Server)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for