Re: Insert performance Tuning

Fusheng Wang allegedly said,on my timestamp of 8/06/2004 12:12 PM:

>
> I have a database with intensive updates, but the updates tend to be slow.
>
> Any suggestions on database tuning on better insertion performance?
>

Just to add to the good advice already sent:

With Oracle, you have to be a little particular about these things. You mention updates. That is the UPDATE statement in Oracle. Then you mention "insertion". Which elicited a joke, but anyways: it is an INSERT statement. Optimizing each of these MAY involve completely different approaches, although of course the strategy would be to minimize overhead.

Definitely: get hold of the concepts and performance tuning guides, they are worth a read to clarify what exactly your problem might be. And please DO include versions and platforms when asking for a performance problem.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam