Muokkaa

Jaa


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.