Hi Guys,
I’ve a requirement to insert 10 lakh records in an empty table and it’s taking unexpectedly more time.
I’m using something like:
Insert /*+ append */ into table_1
Select * from other_tables where con1= con2 and con2 =con3 ;
SQL is returning data within 4-5 minutes ( in Toad) but Insert is taking more time.
I tried inserting 10,000 records using rownum condition as shown below and it took 3.23 minutes for this. So, it'll take around 5 hrs for inserting 10 lakh records.
Can you inform what should be the typical time to insert 10 lakh records and suggestions for improving the 'INSERT' performance.
create table_2 as
Select * from other_tables where con1= con2 and con2 =con3 where rownum <=10000;
Regards,