Oracle Database - Data Loading Hint


The PL/SQL data loading procedures use the following HINTS for performance. They are /*+ APPEND NOLOGGING PARALLEL */

  • Append: - When “Append” hint is used in a PL/SQL INSERT statement, Oracle will perform a DIRECT Load of data and hence will be fast. It's known as direct path insert
  • NoLogging : - When "NoLogging" hint is provided, Oracle will not perform any logging operations for this statement
  • Parallel: - Oracle will make use of Parallel Loading when “Parallel” hint is used in SQL Statement.

Powered by ComboStrap