请解释一下plsql中的/*+APPEND*/的意思

Question

[code="java"]DECLARE
N NUMBER(3,0);
BEGIN
dbms_output.put_line('start baking.......');
DELETE FROM DEPTBACK;
INSERT /* +APPEND / INTO DEPTBACK SELECT * FROM DEPT;
SELECT COUNT() INTO N FROM DEPT;
DBMS_OUTPUT.PUT_LINE('处理数据 '||N||' 条');
dbms_output.put_line('end baking.........');
END;[/code]
看到这样一段代码， /* +APPEND */ 是什么意思啊，没找着答案。

Answer 1

The APPEND hint lets you enable direct-path INSERT if your database is running in serial mode. Your database is in serial mode if you are not using Enterprise Edition. Conventional INSERT is the default in serial mode, and direct-path INSERT is the default in parallel mode.
In direct-path INSERT, data is appended to the end of the table, rather than using existing space currently allocated to the table. As a result, direct-path INSERT can be considerably faster than conventional INSERT.