Oracle Database - Data Loading Hint

Table of Contents

1 - About

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.
db/oracle/hint_load.txt · Last modified: 2017/09/06 19:28 by gerardnico