Posted by Ed Murphy on 06/30/07 01:53

Roy Harvey wrote:

> On Fri, 29 Jun 2007 07:28:03 -0700, teddysnips@hotmail.com wrote:
>
>> SELECT COUNT(*) AS NumRows FROM Answer
>>
>> It returned 1,919,456. However, if I click on the Answer table in
>> Enterprise Manager and select Properties it tells me that there are
>> 1,919,421 rows. I've tried doing a refresh but it didn't work.
>
> Those statistics are not always accurate. To fix them run
>
> DBCC UPDATEUSAGE(0) WITH COUNT_ROWS

Is it COUNT(*) or EM - Properties that is sometimes inaccurate? Under
what circumstances may it be inaccurate?

• Next in forum: Re: Combining Values
• Prev in forum: Re: Performance between Standard Join and Inner Join
• Thread view: Re: Mismatch between Count(*) and Properties -> Rows

[Reply to this message]