[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