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

On Dec 9, 3:53 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> 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?

I am; apparently you're not as you persist in claiming at one time the table WAS empty when statistics were gathered when, in actuality, that isn't the case.

David Fitzjarrell Received on Mon Dec 10 2007 - 08:00:46 CST