> > On MS SQL Server 2000, one can pass a field name to the COUNT function, and > > though I haven't yet seen any difference in the results between the two, the > > queries run faster with COUNT(<field>) than with COUNT(*). > > COUNT(fieldname) provides the count of rows where the data in 'fieldname' is > non-null. COUNT(*) provides the total count of rows:
Ah. I guess that pretty much explains that. I seldom do counts without a WHERE clause of some sort that would preclude counting nulls in the first place. Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]