Find ST_GRIDS using query Oracle 19c

[yockee]

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

[FrédéricPRALLY]

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

[sorpigal]

A bit late, but this is how you can find a existing st_grids value from an existing spatial index:

select sgi.grid.grid1 || ‘,’ || sgi. grid.grid2 || ‘,’ || sgi. grid.grid3 as grid from sde.st_geometry_index sgi where owner = ‘SDE’ and table_name = ‘STREET’;