Check also Jonathan Lewis
CREATE TABLE new_table as select <do the update "here"> from old_table;
973979 wrote:Can't really suggest a better weay wothout knowing the way you are doing it now.
I have to update a table containing 22 miillion records(with duplicates no key column). where the update record count will be around 6 lachs.
would you please suggest me a better way to write update procedure. I implemented primary steps like index creation and other advance concepts..or methods.
Thanks in advance