OraFAQ Forum: Performance Tuning » performance issues in insert stmt

Home » RDBMS Server » Performance Tuning » performance issues in insert stmt (Oracle, 10g, windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

performance issues in insert stmt [message #335680]

Wed, 23 July 2008 05:09

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

Report message to a moderator