Ask about INSERT with three options
A question about INSERT,
I have about 1 million records and need insert into table. Ok, I gave three solutions:
1. INSERT INTO <table1> SELECT ... FROM <table2>
2. Use BULK COLLECT INTO <collection_array> LIMIT 100 and use FORALL to insert data into <table2>
3. Use INSERT /*+ APPEND*/ INTO <table1> SELECT ... FROM <table2>
I am a fan of using BULK COLLECT and LIMIT.
Can anyone give me some advise about them and which method is best ? My db is 9.2.0.4
Thanks