Re: Empty Table
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jaromir nemec <jaromir@xxxxxxxxxxxx>
- Date: Mon, 24 Jan 2005 15:05:38 -0800
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
Other related posts:
