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 - 08:46:21 CST
