Thanks Doug, I was doing an UPATE on 100 million rows and I was updating an indexed column, it was also the column that I was basing my seach on.
UPDATE "Calls" SET "GroupCode"='100 my street' WHERE "GroupCode"='' AND "Site"='000005' GroupCode was Indexed. I dropped the index and the query ran in under one hour. Now I have been running Vaccum Analyze for three days...... Thanks, -Aaron Held ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
