The existing form of the update article

The Update table_A set name='abcd' where table_A is not null;
Commit;

Above, for example, you need to perform thousands of, but the processing time is about 14 hours, want to improve efficiency, how to reduce the execution time Update article?

Which under the guidance of the great god help, thanks!

CodePudding user response:

Try parallel execution task,

CodePudding user response:

Thank you very much, have a try tomorrow

CodePudding user response:

The

refer to the original poster qq_35644524 response:

existing form of the update article

The Update table_A set name='abcd' where table_A is not null;
Commit;

Above, for example, you need to perform thousands of, but the processing time is about 14 hours, want to improve efficiency, how to reduce the execution time Update article?

Which under the guidance of the great god help, thanks!

Thousands of records, 14 hours? Crazy,
Where table_A is not null; Table_A a field name?
See if lock the data

CodePudding user response:

I'm sorry, write wrong
The Update table_A set name='abcd' where the name is not null;
Commit;
The name field is not empty,
Each table has several fields of data need to be updated, are also written above,