Re: dba_tables does not show num_rows
From: Roger Snowden <snowden_at_haven.ios.com>
Date: 1996/02/19
Message-ID: <4ga57a$l7i_at_news.ios.com>#1/1
Date: 1996/02/19
Message-ID: <4ga57a$l7i_at_news.ios.com>#1/1
Naga Nalluri (nnalluri_at_fantasy.sdt.com) wrote:
: Am I incorrect in assuming the num_rows column in dba_tables
: shows the number of rows in that table.
Only if the statistics are current. You need to run
analyze table <tablename> estimate statistics
this will get you a fairly accurate estimate of the number of rows. You can get the precise number of rows with the non-estimate variant- the exact syntax has slipped my mind. It runs considerably longer for a large table, since it analyzes the indexes also. So, use the estimate if you can.
Roger
snowden_at_synergy.net
Received on Mon Feb 19 1996 - 00:00:00 CET