1 million rows/second is the WORST to expect

[@JoniPriya]

you are my amazing (guru means) teacher ,love you for all these lessons,god bless you connor

[@QueryTuner]

I like Connor's approach - but, as he said, the most important hint for testing is always "Just try it!" 🙂 Greetings from Good Old Germany/Hessen .

[@DatabaseDude]

Fortune favours the brave :-)

[@ashumCR]

I did the same test with 6,148,900 rows from dba_objects (110797 blocks) and it took 19 seconds. 🤔

[@DatabaseDude]

Did you copy DBA_OBJECTS first to somewhere else like I did? DBA_OBJECTS is a complex view in its own right.

[@ashumCR]

@@DatabaseDude Yes, I used the same code from your video. My DBA_OBJECTS is a little bit bigger due our custom objects.

[@vikram4755]

APPEND is definitely fast, but if we run two thread in parallel then APPEND wont work. Anyways thanks for giving the benchmark :)

[@DatabaseDude]

Yes, but INSERT /*+ APPEND PARALLEL */ will definitely work