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 not (since NULL is a

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

Count() needs to extract the field from the record, tallying only those that are NOT NULL. Count(*) returns the total number of records in the table, with no need to extract a specific field. When looking into efficiency, try using the .explain/explain feature. asql> explain select count(a) f