Re: UPDATE

What?

First, of all if you remove the index hint what does the explain plan look like and how long does it take to run?

Second, what happens to the table A columns when there is no matching row returned by the coordinated subquery or is there always a matching row? You may need to add an EXISTS condition to the outer query. HTH -- Mark D Powell -- Received on Wed Feb 02 2005 - 09:49:32 CST