I remember a fte article on it. This has some info on select commands. http://www.razzak.com/fte/pdf/RBG90_GainingSpeedWithProgramming.pdf
Dan Goldberg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Charles Parks Sent: Wednesday, January 06, 2010 12:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Selecting from a large table 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
