Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query that fetch whether any record exist

Re: Query that fetch whether any record exist

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Sun, 9 Jan 2000 18:49:37 +0100
Message-ID: <85ahp1$1ef1g$1@fu-berlin.de>


What about

select count(1) from
tablename
where ...
and rownum < 2

Returns 0 if not record exists, 1 if any record with the where clause exists. Stops reading after first row.

Hth,
Uli

> What is the fastest method to check whether ANY record satesfy the
> WHERE clause? For example, the following query:
> SELECT COUNT (*) FROM tableX
> WHERE ...
> May require full table scan in order to return number of records with the
> specified criteria. Same with any MIN function usage, while all I want is
> a boolean value specifying whether any record exist, i.e. one that will
> stop execution once the first record is found.
>
> Any idea?
>
> Thanks,
> Maoz
>
>
Received on Sun Jan 09 2000 - 11:49:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US