If Query takes 1 hour I would look at it first.
Housing with bulk update should give you a nice boost thought.
On Sun, 20 May 2018, 22:30 amonte, <ax.mount@xxxxxxxxx> wrote:
Hello Andy
The SQL takes around 1 hour, the updates takes around another 2000 seconds
or so. I will check the recommendations from Jacek, Pawel and Vikas. Look
promising.
Thank you
2018-05-20 23:14 GMT+02:00 Andy Sayer <andysayer@xxxxxxxxx>:
What sort of timings are you actually getting here and what do you need
to be getting?
Have you looked into where the time is really going? The performance
impact of 2 million (*2) context switches isn’t negligable but it’s not
going to turn something from way too slow to okay.
How long does the SQL in your for cursor take to execute and fetch 2
million results?
How long does one individual update take? Have you looked at the
execution plan of that?
Are you updating a table that you are querying inside that loop? (Causing
you to read undo you’ve just generated)
Hopefully that gets us looking in the right direction,
Andrew