Re: fastest way to count number of records
From: bigt <ctaustin_at_hotmail.com>
Date: 17 Jun 2002 20:42:43 -0700
Message-ID: <cd68b082.0206171942.3895e395_at_posting.google.com>
Date: 17 Jun 2002 20:42:43 -0700
Message-ID: <cd68b082.0206171942.3895e395_at_posting.google.com>
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<nc2P8.211312$352.13763_at_sccrnsc02>...
> That's it.
> Jim
> "qazmlp" <qazmlp1209_at_rediffmail.com> wrote in message
> news:db9bbf31.0206160621.3bf080a6_at_posting.google.com...
> > What is the fastest way to count the number of records in a Table?
> >
> > Currently I'm using this:
> > SQL> select count(*) from TableName;
I have read many conflicting reports on this. Some articles suggest that select count(0) from TableName; is faster. The select count(*) may need to look at all of the columns first, where as the count(0) does not. Received on Tue Jun 18 2002 - 05:42:43 CEST