Re: Perf Tuning

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 13 May 2002 23:28:32 GMT
Message-ID: <3CE04C20.DE462353@exesolutions.com>

Alex Ivascu wrote:

> Is this true? I always thought that using select count(indexedcolumn) from
> table is faster than select count(*) from table... am I wrong???
>
> "In Oracle, the execution plan for the 'select count(*)' and 'select
> count(primary key)' is identical, which means that there is no difference
> between two queries in terms of performance..."
>
> Any links or comments are more than welcomed!!! I need to figure this
> out..... TIA!
>
> Alex Ivascu

If it ever was ... it isn't any more.

I think this myth has had its feet put to the fire.

Several of us have run benchmarks with tens to hundreds of millions of records and could not detect a difference.

Daniel Morgan Received on Mon May 13 2002 - 18:28:32 CDT