Re: "Not in" subquery

On Jun 6, 3:46 pm, Amritha.Da..._at_gmail.com wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

"Urgent" is not a newsgroup mantra. If this truly IS 'urgent' possibly you should pay a consultant to work on this on-site.

David Fitzjarrell Received on Wed Jun 06 2007 - 22:58:25 CEST