I am processing massive updates to tables - usually between 150 million and 200 million rows updating. The queries can grind for 30-48 hours before finishing.
I want to reduce processing time - will LOOP statements to select sub-sets of the data assist in performance? The first table has 168...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.