LinkedIn
Copied!

Table of Contents

Index tables

Version:

Only available versions of this content are shown in the dropdown

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?

Have a question? Get answers now.

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