Consider creating an index if the queries that are associated with Content Consistency Checker document re-indexing by document class return a million or more records.
create index I_STORAGE_OBJID on docversion (storage_area_id, object_id)
To improve the performance of document insertions and document updates, as well as reduce storage costs, you can remove this index after you have completed the associated tasks. However, if the operations are performed on a regular basis, you might want to keep the index to avoid having to create it more than once.