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 ?
Views
Replies
Total Likes
Hi @Klaster ,
This is nice idea as direct-path insert can perform significantly better than conventional insert.
However, there are some constraints here:
Regards,
Milan
Views
Replies
Total Likes