[RBASE-L] - Selecting from a large table

[Charles Parks]

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