Re: Perf Tuning

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 14 May 2002 15:13:21 GMT
Message-ID: <3CE12990.802493CB@exesolutions.com>

"Howard J. Rogers" wrote:

> No it's not. Done and dusted to death within the last month or two on this
> very newsgroup.
>
> Myth 3272.
>
> Regards
> HJR
>
> "Sergey M" <msu_at_pronto.msk.ru> wrote in message
> news:abqi6p$2orf$1_at_serv2.vsi.ru...
> >
> > "Alex Ivascu" <alex_at_ivascu.com> wrote in message
> > news:pNXD8.73018$071.26290917_at_typhoon1.we.ipsvc.net...
> > > Is this true? I always thought that using select count(indexedcolumn)
> > from
> > > table is faster than select count(*) from table... am I wrong???
> >
> > Wrong! And if "indexedcolumn" is NULL. It is mean what this didn't index,
> > so I think Query "select count(1) from table" is faster.
> >
> > Sergey M.
> >
> >

I've got an idea for the group ... how about we get suggestions of myths, or suspected myths, that need to be evaluated with 8.1.7 and 9.0.2 and then see what we can do about setting the record straight. This could be a great public service and I volunteer time on one of my servers (8.1.7.3) to the quest.

Daniel Morgan Received on Tue May 14 2002 - 10:13:21 CDT