Re: Defragmenting table

From: Yong Huang <yhuang_at_indigopool.com>
Date: Mon, 18 Sep 2000 17:40:27 -0500
Message-ID: <8q65qs$f9q$1@news.sinet.slb.com>

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(*).
Received on Mon Sep 18 2000 - 17:40:27 CDT