Page 1 of 1
DB2 Write/Append vs Load
Posted: Mon Sep 17, 2007 10:48 pm
by Havoc
Will there be an increase in performance if the 'Load' option is used versus the Write/Append mode if the target table is not partitioned?
Thanks in advance
![Smile :)](./images/smilies/icon_smile.gif)
Posted: Mon Sep 17, 2007 11:56 pm
by stefanfrost1
If your volumes are large enough load will be much faster than write/append regardless of your database is partitioned or not.
Posted: Tue Sep 18, 2007 12:52 am
by ray.wurlod
Define "performance". If you mean will there be more presentations of "Hamlet on Ice", then I doubt it.