The following INSERT statement executed by the SoD_Rule_Pkg (Segregation of Duties Rule Package) was reported as running too slow in RSA Identity Governance & Lifecycle during SoD rule execution.
INSERT INTO GTT_BUCKET1_APPS
(APPLICATION_ID, APP_CORRELATION_ATTRIBUTE, RULE_ID)
SELECT APPLICATION_ID, APP_CORRELATION_VALUE, RULE_ID FROM
(
SELECT GTT.APPLICATION_ID, CAV.COLUMN_VALUE AS APP_CORRELATION_VALUE, GTT.RULE_ID
FROM GTT_BUCKET1_VIOLATIONS GTT,
TABLE(UTILITIES_PKG.TOKENIZER(APP_CORRELATION_ATTRIBUTE,',')) CAV
)
MINUS
SELECT APPLICATION_ID, APP_CORRELATION_ATTRIBUTE, RULE_ID FROM GTT_BUCKET1_APPS;