Home » RDBMS Server » Performance Tuning » performance issues in insert stmt (Oracle, 10g, windows XP)
performance issues in insert stmt [message #335680] Wed, 23 July 2008 05:09 Go to next message
Messages: 68
Registered: June 2008
I'm new to performance tuning. But need suggestions in one issue:

One table has got millions of records, and need to be inserted into another table (No constraints).If duplicates are found they should be inserted into other 3rd table. This can be done with the stored procedure.

So what are the tips we need to follow to improve the performance, so that it takes less time for millions of records...

Thank you

Re: performance issues in insert stmt [message #335693 is a reply to message #335680] Wed, 23 July 2008 05:28 Go to previous message
Michel Cadot
Messages: 63908
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer than to your other same posts yesterday:

Previous Topic: Slow query with customer data
Next Topic: Avoiding : ORA-00470: LGWR process terminated with error
Goto Forum:

Current Time: Fri Oct 21 08:53:31 CDT 2016

Total time taken to generate the page: 0.08174 seconds