Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: NUM_ROWS vs COUNT(*) anomaly
Sybrand,
OK, forgive my ignorance, but where does it get the value from if the table has never been analysed?
Sarah
Sybrand Bakker wrote:
> The value in the dictionary is a result of ANALYZE table. This value is NOT
> updated dynamically, and you should not rely on it. The Count(*) result is
> correct.
>
> Hth,
>
<SNIP> Received on Thu Jan 13 2000 - 05:09:50 CST
![]() |
![]() |