Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: query for # of rows

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US