Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Perf Tuning
If you did one before the other then the caching of the index in ram would
make a difference.
Jim
"Alex Ivascu" <alex_at_ivascu.com> wrote in message
news:j0YD8.73019$071.26298968_at_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 - 20:40:56 CDT