Performance Improvement of Billing Currency Conversion Process to reduce SQL Execution time by 1300%

Problem Statement
Billing Job Stream running longer due to large volume of transactional data. Billing currency conversion is running longer due to customizations implemented. The custom SQL were taking 50% of the entire process run time.

Solution
There was a need to add the criteria as HDR.PROCESS_INSTANCE =%ProcessInstance to limit the selection range only to current process. In Development and SIT Same SQL executed in 1 Second against 1300 Seconds before the change. This improved the performance by 3 Hours daily by 9 schedules. During the Month End Closure same Process ran around 40 Minutes and drastically come down to 1 minute. This improved Job Run time 2:30 hours to 3:30 hours daily.
https://hexaware.com/