Re: informatio on sys and system tables

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 11 Sep 1999 03:28:31 GMT
Message-ID: <37dec24d.9789977@netnews.worldnet.att.net>

The NUM_ROWS column only gets set when you analyze the table. You do that using the ANALYZE command, like this:

ANALYZE TABLE table_name COMPUTE STATISTICS;

When you analyze a table, Oracle basically reads the table, counts up the rows, and stores that value in NUM_ROWS. The value is not maintained automatically. It's static until you analyze thte table again.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Thu, 9 Sep 1999 12:45:52 -0600, "Larry Pettit" <larry.pettit_at_ps.net> wrote:

>here can you find detailed information on sys and system tables? Is the
>total row count information for a specific table contained in system tables
>or do you always have to use count(*). I tried num_rows from user_tables
>and all_tables but it didn't help much.
Received on Fri Sep 10 1999 - 22:28:31 CDT