Oracle Database APPEND HINT


Example

"Use DIRECT PATH method for inserting new rows".

The APPEND hint instructs the engine to use direct path load. This means that the engine will not use a conventional insert using memory structures and standard locks, but will write directly to the tablespace the data. Always creates new blocks which are appended to the table's segment. This will be faster, but have some limitations:

  • You cannot read from the table you appended in the same session until you commmit or rollback the transaction.
  • If there are triggers defined on the table Oracle will not use direct path(it's a different story for sqlldr loads).
  • others

Example.

INSERT /*+append*/ INTO Employees
SELECT *
FROM Employees;