Mallah,
> Got it , you mean to say userid being pkey is affecting the method of
> implicit join being made by the update stmt.
More to the point, the PKey index doesn't help the db retrieve the rows to
join at all. It might if only 1,000 rows matched, but not with 150,000
matching rows.
-Josh Berkus