Re: Oracle Sub Query "not in" problem

<Amritha.Datta_at_gmail.com> schreef in bericht news:1181161552.973055.222230_at_q19g2000prn.googlegroups.com...
> Is there any alternative query to the below one?
>
>
> update RTable set Reason = "XYZ"
> Where FKey = 1234
> and SFKey = 1
> and Reason Is Null
> and F_ID not in ( Select F_ID from RTable
> Where FKey = 1234
> and SFKey = 1
> and TO_NUMBER(REL_CD) = 1
> and Reason Is Null);
>
> "not in" in the above query is taking alot of time and it is timing
> out.
>
> Please Advise.
>
> Thanks
>

I think you got an answer to this two days ago...... Received on Fri Jun 08 2007 - 11:40:29 CEST