Re: "Not in" subquery

On Jun 6, 3:22 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

I can only presume there is an index on (FKey,SFKey)? Also, why are you using full quotes around your replacement text ("XYZ")? Those should be single-quotes ('XYZ').

Of course we can't really say much without an Oracle release (to four numbers) and an explain plan...

David Fitzjarrell Received on Wed Jun 06 2007 - 15:31:19 CDT