Query that fetch whether any record exist

From: Maoz Mussel <maoz_at_mindcti.com>
Date: Sun, 9 Jan 2000 18:31:47 +0200
Message-ID: <85ad31$jeh$1_at_news.netvision.net.il>

[Quoted] [Quoted] 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 - 17:31:47 CET