DB2 Write/Append vs Load

Havoc · Post by **Havoc** » Mon Sep 17, 2007 10:48 pm

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

stefanfrost1 · Post by **stefanfrost1** » Mon Sep 17, 2007 11:56 pm

If your volumes are large enough load will be much faster than write/append regardless of your database is partitioned or not.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 18, 2007 12:52 am

Define "performance". If you mean will there be more presentations of "Hamlet on Ice", then I doubt it.