11-29-2018 08:15 AM
Greetings!
What is the best way to manage a large number of updates to sql server/oracle? Currently, I have a sql server execute where I have the update statement dynamically written to set only the fields I need to update based on 2-3 conditions in the where clause. I have about 250K updates to process. I’d like to know how to best process large volume updates in a short time frame.
Thanks!
Fernando