Refresh collection snapshot performance issue
Hi,
We are facing performance issue with RCS launch by planing data pull program.
There is increse in run time than 100 minutes. Usually it completes in 80 minutes now taking 200 minutes to complete.
We did some analysis found that WIP table having more data and that is affecting the over all perfromance.
We did reorg of table but still there is no improvement.
If we run GSS for WIP and associated MLOG table having huge data is this usefull ??
Any suggesion on this ??