Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

Home -> Community -> Usenet -> c.d.o.server -> Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

From: <fitzjarrell_at_cox.net>
Date: Thu, 13 Dec 2007 07:10:43 -0800 (PST)
Message-ID: <084efa40-ba74-479d-a970-5577caa4aec5@e10g2000prf.googlegroups.com>

On Dec 13, 8:57 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Dec 13, 8:59 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
> snip
>
> > Look again, I posted an example proving the contrary to your claim
> > about empty table statistics being retained after the table has been
> > loaded.
>
> I did not make any such claim. You guessed about the possible
> existence of an unproven bug in 9206 on windows. I don't see any
> example proving that.

The OP has posted such an example, in his original post and in followup responses to it.

David Fitzjarrell Received on Thu Dec 13 2007 - 09:10:43 CST