Re: [sqlite] [EXTERNAL] Is there a performance difference between COUNT(*) and COUNT(name)

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

Re: [sqlite] [EXTERNAL] Is there a performance difference between COUNT(*) and COUNT(name)

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