Re: Defragmenting table

From: FGuelfucci <guelfucci_at_my-deja.com>
Date: Tue, 19 Sep 2000 07:00:58 GMT
Message-ID: <8q72v3$l9u$1@nnrp1.deja.com>

In my case i have found it more efficient to use count(rowid) rather than row(*), but i don't think that the savings are worth the effort. Florent

In article <8q65qs$f9q$1_at_news.sinet.slb.com>, "Yong Huang" <yhuang_at_indigopool.com> wrote:
> Have you done a benchmark comparing count(rowid) with count(*)? Or
for this
> matter comparing them with count(1)? This urban legend has been on
around
> for a long time.
>
> Honestly I haven't benchmarked. I use count(*) because * is easy to
find on
> the keyboard (after pressing "(").
>
> Yong Huang
> yhuang_at_indigopool.com
>
> Eoin Gardiner <eoin7_at_my-deja.com> wrote in message
> news:8q5npc$31h$1_at_nnrp1.deja.com...
> > I'm not sure this will help:
> >
> > Firstly, select count(rowid) is more efficient than using count(*).
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 19 2000 - 02:00:58 CDT