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

On Dec 9, 3:29 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:

snip
>
> You keep harping on this table being empty when stats are gathered,
> and it's been said more than once by the OP that this is not the
> case.

In a different post I noted that I had mis-understood that part. Why don't you read that post?

> Now you attempt to sling that hash in another form, yet fail to
> provide proof of your statements. So, let's see if that is really the
> case here; if the table is empty, stats are gathered and then the
> table is poplated and stats re-generated do they remain at 0? I think
> not:

I didn't say that at all. Where exactly are you referring to?

What's with the "slinging that hash stuff"?

The OP is stating that he has a system where the table was analyzed and it was not empty at the time but values of 0 appear in the index stats. Are you not understanding that part? Received on Sun Dec 09 2007 - 15:53:53 CST