On Wed, Sep 6, 2017 at 7:56 AM, Hick Gunter wrote:
> Count() needs to extract the field from the record, tallying
> only those that are NOT NULL.
>
Technically it would not need to "extract" the field, only lookup
the row header and
see whether that field/column is NULL or
NAL] [sqlite] Is there a performance difference between COUNT(*)
and COUNT(name)
I want to know the number of teas I have in stock. For this I use:
SELECT COUNT(Tea)
FROM teaInStock
Tea cannot be NULL, so this is the same as:
SELECT COUNT(*)
FROM teaInStock
​But I find the first more clear.
I almos
2 matches
Mail list logo