Large commit interval
I have a partitioned table with an average row length of 100 bytes and am looking to add 10 million rows to it in one shot. Is there any reason why I shouldn't insert all 10 million with one commit at the end, set the commit frequency to one million or even lower?
This operation will be taking place during production hours where many other tables (including this one) will be updated.
Thanks
0