Hi,
I need to rebuild my spatial indexes using query. This is the query that I am expecting to run :
CREATE INDEX SDE.A280_IX1
ON BANGKAIKAPAL_PT_1K(SHAPE)
INDEXTYPE IS sde.st_spatial_index
PARAMETERS('st_grids=1,3,0 st_srid=32748 tablespace NEW_TBS');
I need to find st_grids value using query. How can I do that ? I have been searching the web and can not find anything.
What I want is something similar in finding SRID : "SELECT sde.st_srid (SHAPE) sridcol FROM SDE.STREET;"
Thankyou
Hi Yockee,
From ArcCatalog you can use this tool Calculate Default Spatial Grid Index or refer to this article Guidelines for choosing a spatial index grid size
Hope this help you,
Best regards