10035: Layer's definition query references field names that are not indexed
Your map layer's definition query references fields that are not indexed, and you have selected the advanced option to prefer attribute queries over spatial queries. It's a good idea to index this field because it is used for querying features when drawing your map.
Solutions
Check the drawing performance of your basemap layer in ArcMap or your map service in the Preview window. See Working with basemap layers or Publishing map services for more information.
- If no changes are needed, you can accept the display performance as is.
- Alternatively, if you want to improve performance, you should index the fields reported to not have indexes. These fields are listed in this warning. See Creating attribute indexes for more information.
More information
Attribute indexes can speed up attribute queries on feature classes and tables. For most types of queries, it is faster to look up a record on an indexed field than it is to search through the entire table.
Generally, you can improve overall performance using attribute indexes on key fields in your datasets. See Creating attribute indexes for more information.