Nileshkul
New User
Joined: 09 May 2016 Posts: 43 Location: India
|
|
|
|
I have a DB2 load utility which has input from cursor to get data from table A and load it in table B. Both the tables are having similar structure, just different schema/division/tablespace etc.
So there is no ORDER BY in cursor and DB2 load specified with SORTKEYS and NUMRECS. Will adding ORDER BY in cursor be any helpful to speed up the LOAD process? Sorry if I missing something here. |
|