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

Home -> Community -> Usenet -> c.d.o.server -> Re: determine num rows in a table without doing a count(*)

Re: determine num rows in a table without doing a count(*)

From: Rocr <rolland.cright_at_pwgsc.gc.ca>
Date: Tue, 27 Mar 2001 08:59:48 -0500
Message-ID: <99q6cf$s6u2@shark.ncr.pwgsc.gc.ca>

PS.

   I cannot and have not run stats.

Cheers,

"Rocr" <rolland.cright_at_pwgsc.gc.ca> wrote in message news:99q68l$s6u1_at_shark.ncr.pwgsc.gc.ca...
> Hi gang,
>
> Is there a data dictionary table that holds a record of the number of
 rows
> in a table.
>
> I need to determine the number of rows without doing a count(*).
>
> Cheers,
> Rocr
>
>
Received on Tue Mar 27 2001 - 07:59:48 CST

Original text of this message

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