Re: SQL EXPERTS ONLY

Simon Stow wrote:
>
> 1. in user_tables there is a NUM_ROWS column so:
>
> select table_name, num_rows from user_tables;
>
> looks like it oughta work, but doesn't, at least not on my database -
> num_rows is null for all tables - maybe it requires something else to be
> switched on?
> Num rows works on the results of estimate statistics. If it hasn't been run,
there are no values. If it has been run a while ago, you will get those "old" values.

-- 
-----------------------------------------------------
Jan-Peter Meyer                                  GSSE
Email:  jan-peter.meyer_at_scg.de
Tel.:   (49) (0)89 636-51729
Fax.:   (49) (0)89 636-51682
-----------------------------------------------------