This discussion is archived
8 Replies Latest reply: Dec 13, 2012 2:37 AM by padders RSS

How to tune INSERT statement to insert more than 4 million records faster.

977159 Newbie
Currently Being Moderated
I have an insert statement whcih inserts records ranging 0.5 million to 5 million into a table on a daily basis. the insert has /*+ append */ in it. I have run the SELECT statement separately and it does not take time. It takes time while inserting into the table. it takes around 26 mins to insert 4.5 million records. For 2 million records it takes 4 mins.

I had tried one EXCHANGE PARTIITION method but in this to insert into another table temp table it is taking same amount of time.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points