Re: Oracle Sub Query "not in" problem

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 8 Jun 2007 11:40:29 +0200
Message-ID: <46692406$0$324$e4fe514c@news.xs4all.nl>

<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 - 04:40:29 CDT