Charles, are you looking for a count, or to determine that there are/is
matching value(s). If it is to know if there are values, add 'AND LIMIT
= 1' to the select count, and it will stop looking as soon as it has
found a value.
Albert
Charles Parks wrote:
I think, I heard somewhere that "in" is not good for speedy selects.
Is there something though that is better to use for "not in"?
The following select statement seems to take awhile to do a count.
SELECT COUNT (*) +
INTO vCount +
INDICATOR viCount +
FROM vwBGProjectInfoTopLevel +
WHERE &fNewST +
AND ClientID NOT IN (SELECT ClientID FROM OldClients) +
AND Principal <> 'MAH' +
AND (INT(ProjNum)) > 9000
