Re: Num_rows in user_tables
From: Tony Rothwell <Tony_at_santen.demon.co.uk>
Date: Fri, 23 Dec 1994 19:25:00 +0000
Message-ID: <788210700snz_at_santen.demon.co.uk>
Date: Fri, 23 Dec 1994 19:25:00 +0000
Message-ID: <788210700snz_at_santen.demon.co.uk>
In article <3daops$r7g_at_news.cais.com>
sarek_at_cais2.cais.com "Scott T Johnson" writes:
> Why does the column user_tables.num_rows
> never have the number of rows in it?
This column (plus some others) is populated when you ANALYZE the table. It is not kept up-to-date automatically by ORACLE, and so is not a replacement for SELECT COUNT(*) FROM table. It and the other columns show the data used during cost-based optimization.
Tony Rothwell tony_at_santen.demon.co.ukReceived on Fri Dec 23 1994 - 20:25:00 CET