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: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer than to your other same posts yesterday:

Previous Topic: criteria for partitioning
Next Topic: need help to optimize the query
Goto Forum:

Current Time: Thu Aug 24 03:53:12 CDT 2017

Total time taken to generate the page: 0.18148 seconds