9 Replies Latest reply: May 11, 2012 8:08 AM by Stew Ashton RSS

    Performance Issue when data inserting into table

      Hi All,
      I am trying to insert records into table TEST from TEST1 based on conditions.But the TEST1 query returns 14952862 records,which are taking more than 8 hours and 30 minutes. Below query i am using in procedure to insert records to TEST table.

      insert /* +append */ into TEST
      select * from TEST1 where sr_no= 195

      Is there any change to tune this query.Please suggest me.