Hard to say. An explain plan and a tkprof would have helped a lot.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Jay" <jwu_at_nctr.fda.gov> wrote in message
news:_AFea.60$N5.4917_at_mencken.net.nih.gov...
> I have a table that has about 100,000 records. The primary key has type of
> number. When I did a 'update column=value where primary_key > number and
> primary < number (about 100 records), it took about 15 minutes. Our
database
> server is a capable machine and this slow update is totally upacceptible.
> After we dropped the table and recreated it, the same update took less
than
> 1 second. I am wondering what change within the datase has made the huge
> performance difference. Thanks.
>
> Jay
>
>
Received on Fri Mar 21 2003 - 09:46:09 CST
