Community

ArcGIS Online Feature Service, Attribute Indexes?

5292
1
12-10-2014 04:45 PM
VishApte
by Esri Contributor
Esri Contributor
‎12-10-2014 04:45 PM

Hi,

I have a query regarding the data stored by ArcGIS Online.

I have uploaded a feature service and I am developing an integration application that queries, adds and updates the data using feature service REST end point.

During "query", I specify where clause using a certain field. I have noticed that the performance is not optimal after loading some data. I want to know if there is any way to specify attribute index on certain field(s) in AGOL feature service. Or is it the case of back end database system automatically generates the indexes based on query statistics?

Anyone knows?

Cheers,

Vish

0 Kudos
1 Reply
VishApte
by Esri Contributor
Esri Contributor
‎03-21-2018 04:18 AM

I have been able to add an attribute index to AGOL feature service. I followed this documentation at https://developers.arcgis.com/rest/services-reference/add-to-definition-feature-layer-.htm#example2 and this thread at https://blogs.esri.com/esri/arcgis/2014/10/19/updating-hosted-feature-services-in-arcgis-online/

 

Key is to use admin REST API on the layer you want to add index to and then use “add to definition” option.