GL Account Analysis report Tunning
Summary:
In ERP we have GL Account Analysis Report used by our Thailand and Malysia country client, But Malysia team reported performance issue for RESA and RETEK source as the report was taking 5hrs and failing in few cases. We have tried to tune the report and found that NVL in period_name parameter is causing issue, if we remove that the report is completing in less time but that makes period name parameter mandatory. Help us to resolve the issue.
this is the condition we have in the report h.period_name = NVL(:p_period, h.period_name)
I tried to change it to h.period_name = :p_period