Sign in to Community
Sign in to view all badges
I wonder how we can change generated SQL statements like
INSERT INTO WKFxxxxxxx (col1,col2.....) SELECT ..........
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 ?
Hi @Klaster ,
This is nice idea as direct-path insert can perform significantly better than conventional insert.
However, there are some constraints here: