Re: dba_tables does not show num_rows

nnalluri_at_fantasy.sdt.com (Naga Nalluri) wrote:
>
>the command:
>> select count(*) from tabx;
>does return the correct number of rows in tabx.
>and I am assuming this is what exists in
>the num_rows field in the dba_tables row for tabx.
>
>Am I incorrect in assuming the num_rows column in dba_tables
>shows the number of rows in that table.
>
>I am running Oracle 7.0.15.4.0 running on HP-UX 9.04.
>
>Please e-mail me if convenient.
>Thanks,
>Naga.
>nnalluri_at_sdt.com
>--
>-------------------
>Naga Nalluri
>nnalluri_at_sdt.com

The statistics in the Data Dictionary tables are not updated until you ANALYZE them. These are the statistics used by the Cost-based Optimizer.

-- 
Mike Morgan
Technology Integration Services - Unix DBA
-------------------------------
email: mike.morgan_at_teldta.com |
301 S. Westfield Road         |
Madison, WI 53705  USA        |
(608)845-4661                 |
-------------------------------