Re: NUM_ROWS vs COUNT(*) anomaly

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 13 Jan 2000 12:43:21 +0100
Message-ID: <947763900.21878.0.pluto.d4ee154e@news.demon.nl>

Import? If you don't do anything about, tables WILL be analysed during import.
Analyze is no act of God, and values are not 'made up' if you query them.

Hth,

--
Sybrand Bakker, Oracle DBA
s. hunter <sarahxhunter_at_NOSPAMTHANX.hotmail.com> wrote in message news:387DB27E.7C8AC395_at_NOSPAMTHANX.hotmail.com...
> 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:43:21 CST