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.

Articles Related