Index tables
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.
Previous topic History tables Next topic Link tables