Re: Need a Fast Row Count
From: <kskasi_at_hotmail.com>
Date: 2000/03/30
Message-ID: <38E291C3.CF3DC237_at_hotmail.com>#1/1
Date: 2000/03/30
Message-ID: <38E291C3.CF3DC237_at_hotmail.com>#1/1
Hi Simone
For your info Count(*) is faster than count(1). Unbeleivable Isn't it. But
thats the fact.
...kasi
Simone Jesse wrote:
> How much faster is your count if you use
> select count(1) from... ?
> In this case only the first column of every row will be read, not the whole
> row!
>
> This might not be as quick as some of the other ideas, but I would be
> interested in the statistics.
> Unfortunately none of my tables is big enough to really make a difference!
>
> Simone
Received on Thu Mar 30 2000 - 00:00:00 CEST