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

if you don't like count(*), try count(1) or sum(3)/3 or 2*sum(0.5)...

"Daniel A. Morgan" wrote:

> > 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(*).
>
> The number of rows in a table is accessible through the field num_rows in the
> views DBA_TABLES, ALL_TABLES, and USER_TABLES.
>
> But you must run analyze on the table or schema before the values are populated.
>
> But I am fascinated ... why can't you run SELECT COUNT(*)?
>
> Daniel A. Morgan
Received on Fri Mar 30 2001 - 21:52:45 CST