Re: Perf Tuning

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 14 May 2002 18:49:11 +1000
Message-ID: <abqj3t$k4r$1@lust.ihug.co.nz>

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.
>
>
Received on Tue May 14 2002 - 03:49:11 CDT