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

From: Steve Bell <swayne.bell_at_sympatico.ca>
Date: Wed, 28 Mar 2001 17:04:54 GMT
Message-ID: <3AC217C7.558301D4@sympatico.ca>

Hi,
If you do analyze your tables, the 'num_rows' field in the USER_TABLES or DBA_TABLES views will tell you what you need. If you don't I'm not aware of a way.

Hope this helps,
Steve

Rocr wrote:

> 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 Wed Mar 28 2001 - 11:04:54 CST