Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBA_TABLES.NUMROWS not equal Count(*) ... Why?

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

From: David Sharples <davidsharples_at_gmail.com>
Date: Thu, 16 Feb 2006 21:36:48 +0000
Message-ID: <be592d550602161336o525922d3ma4524a73ea6fbca8@mail.gmail.com> 





 you need to gather_table_stats not set_table_stats



On 2/16/06, Sam Bootsma <sbootsma_at_gbrownc.on.ca> 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.

>



--
http://www.freelists.org/webpage/oracle-l


Received on Thu Feb 16 2006 - 15:36:48 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US