Hello, I am having a bit of trouble updating a single integer column. My table has around 10 columns and 260 000 records.
update no.records set uid = 2; (uid is an integer. It has a btree index)
This update takes more than 20 minutes to execute. Is this normal? This will be totally unacceptable when my table grows.
Any ideas?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
