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
