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

On Jun 6, 4:44 pm, Amritha.Da... (AT) gmail (DOT) com wrote:
update rtable set reason = 'XYZ'
where rowid in (
select rowid from rtable
where fkey = 1234 and SFKEY = 1 and reason is null and rel_cd != 1
);