IBM DB2

Fastest way to insert large volumes of data from one table to another
Fastest way to insert large volumes of data from one table to another
  1. Declare a cursor
  2. Load from cursor with NONRECOVERABLE option

DECLARE CUR1 CURSOR for SELECT field1,field2 from CBA.VERY_BIG_TABLE

load from CUR1 of cursor replace into CBA.ANOTHER_BIG_TBL NONRECOVERABLE

top of the page