Re: WHATS WRONG WITH DBA_TABLES?
Date: 1996/04/17
Message-ID: <4l1q8b$5st_at_homer.alpha.net>#1/1
Charles Walker (cwalker_at_explorer.csc.com) wrote:
> When I run the following I get no rows
> SQL> SELECT NUM_ROWS FROM SYS.DBA_TABLES WHERE TABLE_NAME ='NEW_MARINES';
you have to "ANALYZE" the table to get these values. Look into the
cost-based optimization related documentation, and the ANALYZE command.
>
> NUM_ROWS
> ----------
--
**************************************************************
* Saad Ahmad *
* Senior Software Engineer *
* McHugh Freeman & Associates, Inc. *
* Ph: (414) 798-7457 *
* Fax: (414) 798-8619 *
* E-Mail: sahmad_at_mfa.com *
**************************************************************
Received on Wed Apr 17 1996 - 00:00:00 CEST