REFRDEL Bypass Procedure

The REFRDEL table maintains a list of deleted records from P6 database tables. However, when an entire project is deleted, a large amount of detailed delete records can be inserted into the REFRDEL table resulting in the potential for downstream performance degradation when joins are made to the REFRDEL table.

The REFRDEL Bypass procedure is an alternative to inserting REFRDEL records for tracking delete records on a large scale. This procedure bypasses the REFRDEL table and simply adds a single delete record for a deleted project and project ID.

By default, the REFRDEL BYPASS procedure is set to 0 (zero).

To enable REFRDEL Bypass, run the following procedure and set to a non-zero value:

SQL> exec SET_REFRDEL_PROJECT_BYPASS(1);

Database triggers check for the value of the REFRDEL BYPASS value and process accordingly.

Note: The bypass procedure is meant only for a PROJECT DELETE operations.

Related Topics