Manage Spatial Indexes for Hosted Feature Layer on Enterprise

[cle444]

Enterprise 10.9.0. Hosted feature layers with frequent data updates. Need to rebuild spatial indexes on a regular basis.

When using AGOL, there is an option in the portal item settings which rebuilds the spatial index to improve performance. The option is not available on Enterprise. 

What are the common ways for rebuilding the spatial indexes for hosted feature layers on Enterprise?

Thanks in advance.

Hua

[cle444]

Anyone who can comment on this question? Thanks

[GarrettMelvin]

We experienced performance issues with a frequently updated polygon hosted feature service, believed to be related to indexes needing to be rebuilt.  A workaround that worked for us was to export the hosted feature service to a FDGB feature class, then through Pro use the Share>Web Layer>Overwrite Web Layer to replace the same HFS.  

[JoshuaPust]

Same process, same issue, same workaround.

[PaulNRWA]

I'm resurrecting an old post.   I'm encountering the same issue on our Enterprise 11.x install.   I cannot figure out how to enable the rebuild indexes for managed layers.   Any ideas?

[GB_-_IanHogan__INFORM_]

Same issue, did you have any success? We have hosted feature layers in AGOL. The  "Rebuild Spatial Index" option just hangs, and once it's hung, it is never available again. It will report a "Creating index: Indexes may take a moment depending upon the amount of data." message, one of which I've had now for a month.

Looking under the hood, the Feature Layer Definition JSON shows an "updateLayerDefinitionStatus" of  "InProgress", but I've found nothing online for that parameter. 

[cle444]

As of today, June 14, 2024, 10.9.1 Enterprise, we are still pretty blind on how the hosted feature layer in the ArcGIS managed datastore works and what kind of best practices to maintain it, e.g. rebuilding indexes. There are growing concerns because we have had more mysterious data store crash incidents in the past year. We now use hosted feature services for short-term or smaller-scale projects and try using SDEs for long-term ongoing updates of required data. We liked the simplicity of the hosted feature service, but the concerns of maintenance, data backup, and stability really made it not the choice for enterprise data storage. We would love to hear if someone out there had some great success maintaining the managed data store!

[Arnaud_Leidgens]

We are very interested by this topic as well. The only workaround that we found is to save all hosted feature layers in a GDB every 5-6 months and overwrite the hosted ones (same answer from technical support). A regular back-up restoration of the datastore helped as well. I though that the "rebuild spatial indexes" feature would become available in the last Entreprise update, as it is for AGOL, but unfortunately that was not the case.