1 of 4

In a recent version there is indeed no difference between count(*) and count(any not null column), with the emphasize on not null :-) Have incidentally covered that topic with a posting: http://uhesse.wordpress.com/2009/10/29/is-countcol-better-than-count/

Kind regards Uwe Hesse

htto://uhesse.wordpress.com