Re: query for # of rows

From: Kenneth C Stahl <BlueSax_at_Unforgetable.com>
Date: Wed, 19 Jan 2000 08:00:41 -0500
Message-ID: <3885B579.24F195C2@Unforgetable.com>

"Igor N. Kolomiyets" wrote:
>
> But don't forget that sometimes select <some_column> from ... faster then
> select count(*) from ...
>
> <dbrah_at_my-deja.com> wrote in message news:85p1jr$5lm$1_at_nnrp1.deja.com...
> > Is there a command to query a table for the number of rows without
> > having to do SELECT *?
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

That is a myth. It hasn't been true in anything above Oracle 7.0 Received on Wed Jan 19 2000 - 07:00:41 CST