How can I recalculate the spatial index for a featureclass in SQL Server programatically?
I already use the interfaces IIndexEdit and IGeometryDefEdit to recalculate the index by cloning the old index, following the example "RebuildSpatialIndex" in the developer help.
But I have to recalculate the extent because of performance issues. I can do it in ArcCatalog (Button "Neu berechnen" in the picture above), but how to reach the functionality programatically?
Thanks for any hint!
Frank
Grüß Dich,
Have you looked into a Python option? This link explains an approach using ArcPy to do what you are looking for.
*** EDITED WITH CORRECT LINK ***
ArcGIS Help 10.2 - Rebuild Indexes (Data Management)
*** EDITED WITH CORRECT LINK ***
Viel Glück,
Shaun
Shaun-
thanks for the hint, but I couldn't find ArcPy functions, that will do the desired work.
I suppose, the task is "too specific", it depends on the given DBMS.
I still hope, someone has an idea...
-Frank
Sorry for the bad link. Here is the correct link. Or you can search on Rebuild Indexes under Data Management.
ArcGIS Help 10.2 - Rebuild Indexes (Data Management)
Shaun
Are you trying to Recalculate the Spatial Index or the Extent of that feature class?
I try to recalculate both. First I rebuild the spatial index but after that the feature class extend is equal to the extent of the feature dataset.
After creating the spatial index I have to recalculate the extent of the feature class (Button "Neu berechnen").