Query that fetch whether any record exist
From: Maoz Mussel <maoz_at_mindcti.com>
Date: 2000/01/09
Message-ID: <85ad0n$jdn$1_at_news.netvision.net.il>#1/1
Date: 2000/01/09
Message-ID: <85ad0n$jdn$1_at_news.netvision.net.il>#1/1
[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 - 00:00:00 CET