Data reviewer perfomance / best practices?

[SusanneByrne-Dronkers__GISP]

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

Thanks,

Susanne

[MarceloMarques]

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.