Re: Oracle much slower than DB2?

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Fri, 06 Jul 2001 13:19:29 GMT
Message-ID: <3b45b8b4.3054919@news-server>

On Wed, 04 Jul 2001 17:57:26 +0200, Burkhard Schultheis <schultheis_at_tde-online.de> wrote:

>Now I've tried it with 3 100 MB redo logs. The time is now 3.4 s. It's
>still too slow!
>

Is the table indexed on the columns you're changing?

Also, make sure that PCTFREE has been set so that you don't get row migration. That will increase the I/O needed. Check for row migration after an update and adjust accordingly.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Jul 06 2001 - 08:19:29 CDT