Skip to main content
Open

ArcGIS Online and Portal feature writers to support adding and updating attribut

Related products:Integrations
  • August 6, 2019
  • 1 reply
  • 35 views

bruceharold
Influencer
Forum|alt.badge.img+19

***Note from Migration:***

Original Title was: ArcGIS Online and Portal feature writers to support adding and updating attribute indices


If you are maintaining large feature layers that will be queried with non-cached expressions then maintaining indices on query fields will prevent full table scans on query. At the REST level it means passing JSON to addToDefinintion or updateDefinition, like this setting up a unique index on a field 'id':

{

"indexes" : [

{

"name" : "idIndex",

"fields" : "Id",

"isAscending" : true,

"isUnique" : true,

"description" : "Unique index on primary key field ID"

}

]

}


If the writer could do this it would help a lot.

1 reply

bruceharold
Influencer
Forum|alt.badge.img+19
  • Author
  • Influencer
  • August 7, 2019

To give a little more context, querying large layers on non-indexed fields can time out silently and just return nothing, so if you're building workspaces that read Online or Portal features you should maintain indices.