Обсуждение: Re: update on a large table

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