Inserting rows into worktables using APPEND (bulk loa...

[Klaster]

Hi,

I wonder how we can change generated SQL statements like

INSERT INTO WKFxxxxxxx (col1,col2.....) SELECT ..........

into

INSERT /*+ append */ INTO WKFxxxxxxx (col1,col2.....) SELECT ..........

which is in fact bulk insert into table (Oracle database) - and it's greatly reduce redo logs size.

Any clues ?

[Milan_Vucetic]

Hi @Klaster ,

This is nice idea as direct-path insert can perform significantly better than conventional insert.

However, there are some constraints here:

• Data is written directly into datafiles, bypassing the buffer cache;
• Free space in the table is not reused;
• Rreferential integrity constraints are ignored.

Regards,

Milan