How to recalculate spatial index using Esri.FileGDB version 1.5.2

Question

I am using Esri.FileGDB in a C# application to open File geodatabase to query and add new records into tables. I found that the insert operation becomes increasingly slow with increasing number of records in tables inside a file geodatabase, so I am thinking how to call recalculate spatial index after inserting a large number of records programmatically, could I have a code example, I searched high and lows but couldn't find any. Thanks.

Aashis · Answer

Hi @TongZhai - To address slower performance like yours, you can drop the indexes before the data insert and recreate them after insertion is complete using the DDL API.  The https://github.com/Esri/arcgis-pro-sdk/wiki/ProSnippets-Geodatabase has code snippets to add/remove both spatial and attribute indexes.