You can apply performance tuning changes to some of the provided IBM® Enterprise Records reports.
The following table describes the performance suggestions related to some of the reports delivered with IBM Enterprise Records.
Report Name | Performance suggestions |
---|---|
Actions Performed by a User | The SQL_query statement associated with this report depends on the I_Event48 index definition. For information about improving audit logging and search performance when Auditing is enabled, see the Improving audit logging a search performance topic in the IBM FileNet® P8 Performance Tuning Guide. |
Folders and Records on Hold | Define a new Index on the Content Platform Engine Database LINK table to help with all hold link-involved queries for RecordHoldLink and RMFolderHoldLink. The column order for this new Link table index is defined as create_date DESC, head_id, tail_id, object_class_id. For more information about the LINK table, see the Database Table Schemas topic in the Content Platform Engine Java and .NET Developer's Guide. |