Some points to keep in mind while using APPEND hint in ORACLE:
I am listing down some points that I came across and had to consider while using an APPEND hint. This might not be a complete list - just throwing out which I think are useful.
It does a direct path insert
Adds rows above high water mark
Parallel hint is always a direct path, if you go parallel, you will be appending.
Insert /*+ append */ will ignore the append hint and use conventional path loading when the table has referential integrity or a trigger.
Only one session can do a direct path load on a table, no other session can do direct path on the same table. Also no other session could also issue insert, update or delete statements on this table.
Feel free to add more points in the comments section...
Feel free to add more points in the comments section...
No comments:
Post a Comment