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 = ] N'tabname'
, [ @indexname = ] N'indexname'
, [ @verboseoutput = ] verboseoutput
, [ @query_sample = ] query_sample
[ ; ]
Arguments and properties
See Spatial index stored procedures - arguments and properties.
Permissions
User must be assigned a public role to access the procedure. Requires READ ACCESS permission on the server and the object.
Examples
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.
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें