nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Server rest URL query very slow on oracle view

SandeepKumar4

Hi,

I created one spatial view on oracle database and publish as a map service in ArcGIS server 10.4, when i am trying a query (simple get count) on ArcGIS server rest page it's taking more than 2 minutes to get result. I already rebuild attribute and spatial indexes.

Can any one suggest how to improve get query result on ArcGIS Server rest URL?

Regards,

Sandeep

Find more posts tagged with

Accepted answers

All comments

Hemant_Angarkar

Archit Srivastava‌, Could you please help with this one? Thanks!

Christian_Wells

Did you register your view with the geodatabase? Or is does this spatial view exist in a standalone DBMS?

One of the reasons this is important is because unregistered spatial views are cast as a subquery when ArcGIS queries the database. The use of a subquery is to ensure no malicious SQL is being sent to the database inadvertently but it also can create some performance issues. However, if you register the view with the geodatabase, it will store the metadata information and no longer send a nested query.

We built the ability to register a view into ArcMap 10.5 as a geoprocessing tool: Register a table or view with the geodatabase—ArcGIS Help | ArcGIS Desktop

SandeepKumar4

Hi Christian, Thanks for the reply.

The option to register with geodatabase is grayed out. The spatial view is in registered database

Please suggest how to proceed on this issue.

Chenna_KishoreMallemala

Hi Sandeep,

as suggested by Mr.Christian, please open the GP tool from the path "toolboxes\system toolboxes\data management tools.tbx\geodatabase administration\register with geodatabase" and follow the instructions.

SandeepKumar4

Hi Mallemala, Thanks for the reply.

Below error occur while using this tool. For your information i am using 10.4.1 ArcGIS Server.

Please suggest how to proceed on this issue.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.