Re: which one is faster

[Szymon Guz <mabewlun@xxxxxxxxx>]

2010/10/26 Grzegorz JaÅkiewicz <gryzman@xxxxxxxxx>

2010/10/26 Szymon Guz <mabewlun@xxxxxxxxx>:

>
> Well, strange. Why is that slower?

To answer that fully, you would need to see the implementation.
suffice to say,

count(a) does:

if (a <> NULL)
{
Âcount++;
}

and count(*) does:

Âcount++;

Yup, I was afraid of that, even if there is not null on the column... but I think usually nobody notices the difference with count.

regards

Szymon