0

When I create a spatial index I can specify some extra parameters, e.g.

CREATE TABLE dbo.Test(
    Id bigint not null,
    Polygon geography not null
)
GO


CREATE SPATIAL INDEX IX_Test_Polygon ON dbo.Test
(
    Polygon
)
USING GEOGRAPHY_AUTO_GRID 
WITH (CELLS_PER_OBJECT = 12)
GO

If I then go to SSMS and script this index, then the script will contain these USING GEOGRAPHY_AUTO_GRID and WITH (CELLS_PER_OBJECT = 12). However, the view sys.indexes does not contain this information.

How can I get this information using SQL, not SSMS.

Improve this question
2
Related questions
3
SQL Server 2008 Spatial Index is not used
1
SQL Server GEOGRAPHY_GRID x & y range
1
how to get the index of a point from geography?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.