Re: Need a Fast Row Count

From: <kskasi_at_hotmail.com>
Date: 2000/03/30
Message-ID: <38E291C3.CF3DC237@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 CST