Indexing Content Platform Engine databases

The performance tuning topics in this section apply specifically to Content Platform Engine and all supported databases.

Improving user property searches
For information about improving user property searches, see the Indexing for Content Platform Engine Searches technote (white paper).
Improving multi-valued property searches
Consider creating the following composite-properties index on the following database tables to improve Content Platform Engine performance during multi-valued property searches.
Create performance enhancing indexes
Consider creating the following indexes to increase the performance of Content Cortex components.
Creating indexes for object-valued properties
Consider creating single-value property indexes when you use object-valued properties (OVPs) that are associated with a large table, such as the docversion table.
Locating the in-use custom “uxy” property column
Sometimes the creation of a custom “uxy” property column fails.
Improving Content Consistency Checker queries
You can tune your Content Consistency Checker queries to improve performance.
Creating an index to improve sweep performance
You can increase the performance of policy-based and job sweeps by creating a covering index on the base table you are sweeping.
Root class search and class-specific search
Using a class-specific search can improve performance of a sweep.

Parent topic: Tuning Content Platform Engine databases