The append mode is the default during a parallel insert operation: data is always inserted into a new block, which is allocated to the table. Therefore, the
APPEND hint is optional. You should use append mode to increase the speed of
INSERT operations, but not when space utilization must be optimized. You can use
NOAPPEND to override append mode.
APPEND hint applies to both serial and parallel insert operation: even serial insertions are faster if you use this hint. The
APPEND hint, however, does require more space and locking overhead.
You can use
APPEND to make the process even faster.
NOLOGGING means that no redo log is generated for the operation.
NOLOGGING is never the default; use it when you want to optimize performance. It should not typically be used when recovery is needed for the table or partition. If recovery is needed, be sure to perform a backup immediately after the operation. Use the
[NO]LOGGING statement to set the appropriate value.