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

Hi Larry,

you might want to use the optimizer statistics. Remember: 'analyze table estimate|compute statistics ' produces estimated|computed sizes of tables.

Use select table_name,num_rows ... from sys.all_tables;

Kind regards,

Toni

In article <33DDEE18.5C465511_at_hkstar.com>, llarry_at_hkstar.com wrote:

> hello everyone,
>
> i just wonder is there a better way to find out how many row of each
> table in
> the database. It is because i am assigned a job to refresh our
> development
> database from the production one.
>
> by 'select count(*)' from each table seems time consuming.
>
> thanks in advance
>
> larry
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  | Please remove            
Marchioninistr.15 81366 Muenchen 49-89-70953202 | _NO_SPAM for email.