Re: "Not in" subquery

[Quoted] [Quoted] On Jun 6, 4:44 pm, fitzjarr..._at_cox.net wrote:
> On Jun 6, 3:23 pm, Amritha.Da..._at_gmail.com wrote:
>
>
>
> > Hello,
>
> > 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
>
> Cross-posting doesn't help you get a faster response.
>
> David Fitzjarrell

Sorry. Please help me as it is urgent requirement.

Sorry again!

Thanks Received on Wed Jun 06 2007 - 22:46:39 CEST