> If you want to get the count including nulls, you can use COUNT(*),
> which returns the number of rows in the set being aggregated (not the
> number of values).
A side question: Is this any faster than using COUNT( colName)? Or
does COUNT() always entail something on the order of iterating through
all the results of the query?
The performance is the same. The only difference is that
COUNT(colName) looks at values and discards nulls, and COUNT(*)
doesn't look at values as it iterates through the data.
- Jeff Lichtman
[EMAIL PROTECTED]
Check out Swazoo Koolak's Web Jukebox at
http://swazoo.com/
