most efficient bulk insert
927978Jun 2 2012 — edited Jun 4 2012I have many different select statements(50-100) that scheme is same.
My issue, how do those select statements result insert one table?
My solution is many "create table as" statements in different sessions for parallel.
Than join created tables with union all.
Union all statement result insert to one table for ctas.
My question is why is ctas statement is fastest?. "create table as select" is 10x faster than "bulk collect and ..forall" and 10-50x "insert into select".
I want to insert one table for different select statements that is same scheme result, with most efficient. How do I?
Thanks