Interesting. I hadn't considered that. So, did you try your query with a NOPARALLEL hint? Jared On Mon, 24 Jan 2005 23:28:36 +0100, jaromir nemec <jaromir@xxxxxxxxxxxx> wrote: > Hi, > > > add a where clause: > > WHERE rownum < 2; > > this is in nearly all cases a very good approach, but there is a small but > dangerous trap. > > There is a constellation performing even with rownum < 2 a full scan of the > total table. No, I don't mean the old joke with rownum > 2! > > This case (true story) is documented in > http://www.db-nemec.com/Selecting_ROWNUM_1.html > > Regards > > Jaromir D.B. Nemec > > ----- Original Message ----- > From: "Jared Still" <jkstill@xxxxxxxxx> > To: <andert@xxxxxxxxx> > Cc: <jacintakean@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> > Sent: Monday, January 24, 2005 7:56 PM > Subject: Re: Empty Table > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l