Re: NUM_ROWS in DBA_TABLES has no values

Karl Penney (aa651_at_ccn.cs.dal.ca) wrote:
: I was trying to write a query to find the number of rows in some
: tables using the NUM_ROWS field on the dictionary table DBA_TABLES
: but all the values are blank. I can't use count(*) on the tables
: themselves because I need to join the results to some other dictionary
: tables to get other info. Why is the NUM_ROWS field blank and how can
: I get is populated with real data.
 

: --
: Karl Penney |~~~~~~| _/^\_ |~~~~~~|
: DMR Group, Halifax, NS | | _/\_\ /_/\_ | |
: aa651_at_cfn.cs.dal.ca | | >___________< | |
: 74203.673_at_compuserve.com |______| | |______|

The NUM_ROWS field is populated by the ANALYZE statement.

ANALYZE table_name COMPUTE STATISTICS;

--
Murray Kaiser                  | Usual gutless disclaimer.. 
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer