Re: Perf Tuning

From: Alex Ivascu <alex_at_ivascu.com>
Date: Mon, 13 May 2002 23:30:23 GMT
Message-ID: <j0YD8.73019$071.26298968@typhoon1.we.ipsvc.net>

Ouch!

I did a simple test w/ 150K rows. It does seem to make a difference (small one), but it does. Wonder why?

Alex
ps Thanks for your assistance, I'm just now trying to dig a little deeper into tuning

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CE04C20.DE462353_at_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:30:23 CDT