Re: Empty Table

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_at_gmail.com> To: <andert_at_gmail.com> Cc: <jacintakean_at_yahoo.com>; <oracle-l_at_freelists.org> Sent: Monday, January 24, 2005 7:56 PM Subject: Re: Empty Table

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