Oracle Database - Data Loading Hint

Card Puncher Data Processing


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.

Discover More
Card Puncher Data Processing
Oracle Database - NOLOGGING

A table of a statement marked as NOLOGGING will bypass the generation. direct path insert The operation will not be logged and then you prevent the redo log to be generated. It's not in the...

Share this page:
Follow us:
Task Runner