We are storing data reviewer in an enterprise geodatabase (Oracle). Is there a list of "attribute" indexes that should be created?
Thanks,
Susanne
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.
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
