RE: Simple Select Return Record - oracle-l - FreeLists

RE: Simple Select Return Record

From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: <vlovsky@xxxxxxxxx>, <jacintakean@xxxxxxxxx>
Date: Thu, 9 Jun 2005 10:44:32 +0200

Hi
 

>select count(*)=20

>from dual

>where exists (select null from employee_tbl where employeeid=3D5);

 

If excellent performance is a must, don't do that. 

To fetch a single row from a query and set a flag is faster.

 

 

HTH

Chris


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

Follow-Ups:
- Re: Simple Select Return Record
  - From: Vlad Sadilovskiy

Other related posts: