Apply appropriate indexes to the object store databases, depending upon the condition you are experiencing, to ensure optimal performance for all IBM® Enterprise Records operations.
Optimal performance of IBM Enterprise Records operations depends on proper database indexing. To ensure optimal performance, you must index the uxx_recordinformation column on the FPOS and ROS object store databases.
For information about other essential performance-related indexes, see the IBM FileNet P8 Performance Tuning Guide in the FileNet® P8 Platform Technical Notices section of the external link.