Skip to main content

Index tables

Suggest edit
Updated on August 25, 2021

Instances of concrete classes derived from the Index- base class support reporting and rapid data access. Such instances are created and deleted by Declare Index rules. For example, the pr-index-assignmentdeps contains rows that correspond to instances of the Index-AssignmentDep class, which supports dependent assignment processing.

Most Pega Platform database tables that support indexes have table names that start with pr_index or pc_index.

Tables that contain rows automatically created and deleted by rules of type Rule-Declare-Index are different from database indexes defined by SQL that is maintained within the database by Oracle or other database software. Both table types support alternate key access to other instances (rows), but the two indexing facilities are independent and unrelated.

Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us