RE: Count(*) Vs Count(1)

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Sat, 16 Dec 2000 13:48:49 -0400
Message-Id: <10712.124780@fatcity.com>

On Fri, 15 Dec 2000, you wrote:
>
> Oracle has optimized the count(*) for performance.
>
> Richard Ji

On a newly-created (index-less) table, count(rowid) returns magnitudes of order faster than count(*) (I believe it only has to read the header vs. the entire row in the datablock. Anybody have the true answer with regards to this?).

Cheers,
GC

-- 
"The opposite of a correct statement is a false statement. But the opposite 
of a profound truth may well be another profound truth." 
                                    --Niels Bohr

Received on Sat Dec 16 2000 - 11:48:49 CST