We add HINT on the standard SQL called workflow_analyzer.sql in order to improve the performance.

We change the standard SQL called workflow_analyzer.sql in order to improve the performance.

The action applied was.

1- Download last version WF analyzer.

2- add hints to workflow_analyzer.sql script.

debug('begin add_signature: SAMIR_OM_WF_4'); -> line 16577

SELECT /*+ use_merge(wi) */ -> hint added

debug('begin add_signature: SAMIR_OM_WF_3'); -> line 16630

SELECT /*+ use_merge(wi) */ -> hint added

3- install The WF analyzer.

4- Run the concurrent program. "Workflow Analyzer"

Do We want to know if this change to the WF Analyzer standard doesn't have an impact on another process?