How to improve the execution time of inserting to a table from selecting rows from a table of million rows in ORACLE?
An empty table T1 where rows have to be inserted by selecting rows from another table T2 in ORACLE. Like, INSERT INTO T1 SELECT * FROM T2; The issue is table T2 has about 10 million of rows. This simple SELECT statement seems to execute around 25-30 secs individually. But when it inserts into T1,…Details