Re: Empty Table

From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
To: <jkstill@xxxxxxxxx>, <andert@xxxxxxxxx>
Date: Mon, 24 Jan 2005 23:28:36 +0100

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



--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Empty Table
From: Jared Still

References:
- Empty Table
  - From: Kean Jacinta
- Re: Empty Table
  - From: Stephen Andert
- Re: Empty Table
  - From: Jared Still

Re: Empty Table

Other related posts: