Content consistency checks that are run with a date range
selected can be optimized for better query performance by adding indexes
to the DocVersion and Annotation database tables.
You can improve query performance for content consistency
checks that are run by using a
Validate by Date Created or
Validate
by Date Modified validation range. To improve query performance,
you append an
Order by statement to the Consistency
Checker SQL statement and add database indexes to the DocVersion and
Annotation tables. The amount of improvement can vary, depending on
the data.
You must be running Content Platform Engine 5.2.1.2-P8CPE-FP002
or later to use this option.
Important: Do not set
the AppendOrderBy option without also creating the related indexes.