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 -- //www.freelists.org/webpage/oracle-l