Most of the tables that support auditing have multiple indexes. When enabling auditing, you have the option of activating all the indexes, or only the primary indexes. Generally, only the primary indexes should be activated in a production database. The non-primary indexes are used for reporting and should be enabled in your archive database. The table below lists the indexes for each of the auditing-related schema tables. See OpenEdge Getting Started: Core Business Services - Security and Auditing for details on the components of each index.