Hi,
This is not going to answer your question of course but did you already try to do this
in 2 steps?
You said that the subquery itself doesn't take very long, so perhaps you can create a
temporary table based on the subquery, then in the update do a join with the temporary
table?
This
Eric Jain wrote:
I can't get the following statement to complete with reasonable time.
I've had it running for over ten hours without getting anywhere. I
suspect (hope) there may be a better way to accomplish what I'm trying
to do (set fields containing unique values to null):
[...]
Using