Re: a performance question

Jay wrote:
>
> 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

Could have been a myriad of problems...A statspack snapshot before and after sure would have helped :-)

Connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"