We have a requirement for search with owner name in the query widget. For this to achive we have done the following steps.
1)We have a geodatabase created in oracle 12c. Created a table with point feature class which has fields with names. Added indexes for the attributes in geodatabase.
2)Created a map document added the layer in that from geodatabase table.
3)Published as map service.
In query widget accessed the map service and doing the query for owner name.
Just to query for 23records it took more than 50 seconds. How can we improve the performance of the query to fetch more records.