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
jyothsna1612
Messages: 68
Registered: June 2008
Member
Hi,
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
Jyothsna

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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer than to your other same posts yesterday:
http://www.orafaq.com/forum/m/335366/102589/#msg_335366

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


Current Time: Sun Dec 04 18:50:26 CST 2016

Total time taken to generate the page: 0.07648 seconds