Select to view content in your preferred language

Data reviewer perfomance / best practices?

548
1
05-02-2018 06:44 AM
SusanneByrne-Dronkers__GISP
New Contributor

We are storing data reviewer in an enterprise geodatabase (Oracle).  Is there a list of "attribute" indexes that should be created?

Thanks,

Susanne

0 Kudos
1 Reply
MarceloMarques
Esri Regular Contributor

When the Reviewer Workspace is created the featureclasses and tables already have indexes that are automatically created, however if revtablemain or the revdataset featureclasses become very large with time then some SQL Queries might become slow, it depends on how the Reviewer application is been used by users, and how users are querying the Reviewer tables and attributes, in such situation is necessary to ask the database administrator to perform a SQL trace to capture, identify and tune the slow SQL queries, a possible result of the tuning might be to add additional indexes to improve performance. I hope this helps.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "About: In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 33 years, my passion for Spatial Databases and GIS data has become a central part of my career.." | “ The mountains are calling and I must go.” – John Muir |
0 Kudos