[V4WS 1.11] Any faster to use COUNT(RecID) instead of COUNT(other
field)?
Steven Ronald
stevenrt39 at yahoo.com.au
Thu Nov 16 21:28:57 CST 2006
Ruslan,
is it any faster/more efficient to use
SELECT MAX(foo),COUNT(RecID) FROM x
instead of
SELECT MAX(foo),COUNT(foo) FROM x
ie, to specify RecID for the COUNT argument? For the
COUNT argument you can use any field so i am wondering
if using the RecID field is more efficient?
Best Regards,
Steven
Send instant messages to your online friends http://au.messenger.yahoo.com
More information about the Valentina
mailing list