Re: What to Count - WAS Re: Newbie ? - Howto find nbr records in a table

--
Alan D. Mills

Jason Jay Weiland wrote in message
<361BD316.B7458F26_at_uclink4.berkeley.edu>...
>Hey Allan,
>
> You could also use Count(1), Count(3), Count(1974) or Count('jay').

It doesn't matter what you count. I know.

>
> I don't have a *really* large table to test the timing against, but I
>cannot imagine the difference to be too great. My co-worker, Ken Geis,
just ran
>the following against a table with about 43,000 records and count(*) was
about
>2/100th of a second faster then count(9). I agree with your point: if you
can
>type Count(9) noticeably faster then COUNT(*), you could make your savings
>there.

I've never noticed any timing differences either.

>
>DECLARE
Received on Thu Oct 08 1998 - 10:40:55 CDT