Please advice , what are all the actions I need to do to improve the performance of EDQ jobs. I have millions of data, somedays it takes 30m to process 300k-400k records, but somedays it takes 7-8 hours to process 800k records. What are the possible steps that can be taken:
The steps that we have already taken to improve the performance are given below, but nothing worked, the duration is still the same.
Replaced the existing views with materialised views
Deselected the 'Staged Data' option during job configuration to directly stream the data
Tried to replace the existing SQL query with a new staging table
Please advise if there are any other ways for the performance tuning.
Thanks,
Anamika