Re: Num_rows in user_tables

From: kenneth d atkins, s=david m thomas <Kenneth.D.Atkins_at_tek.com>
Date: 23 Dec 1994 19:16:25 GMT
Message-ID: <3df7m9$a8k_at_goodnews.wv.tek.com>

This column is filled by the ANALYZE TABLE command. If you want to see values in this column use the command:

  ANALYZE TABLE tablename COMPUTE STATISTICS;

and the number of rows will be there (other columns will be filled also). This information is used by the cost-based optimizer in V7.

Of course it is not automatically kept in sync with the actual table, so it will only have the correct number of rows if no rows are added or deleted after the ANALYZE command.

---

Kenneth Atkins
Financial Data Systems Incorporated (FDSI) Kenneth.D.Atkins_at_tek.com

---

sarek_at_cais2.cais.com (Scott T Johnson) wrote:
>
> Why does the column user_tables.num_rows
> never have the number of rows in it?
>
> Scott
>
> --
> ------------------------------------------------------------------------
> Scott T. Johnson Internet: sarek_at_cais.com
> SHL Systemhouse, Inc. CIS: 73052,2500
> +1 703 438-7300 "Resistance is futile, Number one" -Picard
> ------------------------------------------------------------------------
Received on Fri Dec 23 1994 - 20:16:25 CET