Re: DBA_TABLES.NUMROWS not equal Count(*) ... Why?

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: sbootsma@xxxxxxxxxxxxx
  • Date: Thu, 16 Feb 2006 21:36:48 +0000

 you need to gather_table_stats not set_table_stats

On 2/16/06, Sam Bootsma <sbootsma@xxxxxxxxxxxxx> wrote:
>
>  Dbms_stats tells me there are 2000 rows, but count(*) says there are
> about 3.2 million.  Can anybody explain to me what is going on?  Please
> see below.  Thanks.
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2006