Re: [Q] how to find how many row in each table in database?

Larry Leung wrote:
>
> but i just wonder is that possible not to really read thru every row
> of every table in order to find this out.
> like does oracle maintain a row count for each table in some system
> table.
>

If you analyze your tables frequently (e.g. by executing 'analyze table xxx compute statistics'), you can use column num_rows of the system view user_tables (or all_tables).

Marc Billiet Received on Tue Aug 05 1997 - 00:00:00 CDT