Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!feeder1-2.proxad.net!64.233.178.134.MISMATCH!postnews.google.com!d30g2000prg.googlegroups.com!not-for-mail From: "fitzjarrell@cox.net" Newsgroups: comp.databases.oracle.server Subject: Re: "Not in" subquery Date: Wed, 06 Jun 2007 13:47:49 -0700 Organization: http://groups.google.com Lines: 57 Message-ID: <1181162869.947308.234880@d30g2000prg.googlegroups.com> References: <1181161334.045765.206080@z28g2000prd.googlegroups.com> <1181161879.799618.189300@g37g2000prf.googlegroups.com> <1181162608.355821.208610@o11g2000prd.googlegroups.com> NNTP-Posting-Host: 138.32.32.166 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1181162870 32448 127.0.0.1 (6 Jun 2007 20:47:50 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 6 Jun 2007 20:47:50 +0000 (UTC) In-Reply-To: <1181162608.355821.208610@o11g2000prd.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: d30g2000prg.googlegroups.com; posting-host=138.32.32.166; posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4 Xref: news.f.de.plusline.net comp.databases.oracle.server:199047 On Jun 6, 3:43 pm, Amritha.Da...@gmail.com wrote: > On Jun 6, 4:31 pm, "fitzjarr...@cox.net" wrote: > > > > > > > On Jun 6, 3:22 pm, Amritha.Da...@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 > > Sorry It should be 'XYZ' I am using oracle 9i. > > Thanks- Hide quoted text - > > - Show quoted text - 'Oracle 9i' doesn't tell us much as that spans releases from 9.0.1.x through 9.2.0.x, with functionality differences between them. The request was for: * Oracle release to four numbers : 9.x.y.z * An explain plan for your statement Please provide both. David Fitzjarrell