Re: WHATS WRONG WITH DBA_TABLES?

Charles Walker wrote:
>
> When I run the following I get no rows
>
> SQL> SELECT NUM_ROWS FROM SYS.DBA_TABLES WHERE TABLE_NAME ='NEW_MARINES';
>
> NUM_ROWS
> ----------
>
> But when I do a count I get rows...whats up?
>
> SQL> SELECT COUNT(*) FROM TFDSS.NEW_MARINES;
>
> COUNT(*)
> ----------
> 569438You have to run the ANALYZE command on the table object
'NEW_MARINES' before the statistics for that object are populated in sys.dba_tables.

-- 
Ken Mills
West Chester, PA.
mills_at_cpcuiia.org