Re: index_stats no populating

Comments embedded.
balvey_at_comcast.net wrote:
> I'm new to this DBA stuff and I can't seem to get index_stats to
> populate. I'm running 9.2.0.5 with the compatible parameter set to
> 8.1.0, I don't think that should matter though.

Really? Disabling all of the 9i and 9iR2 features in a 9.2.0.5 database doesn't matter? I would think otherwise.

> I run
> analyze index [index_name] validate structure;

Which doesn't populate anything.

> that returns Index analyzed, but the table does not populate.

See above.

> I've also tried running
> analyze index [index_name] compute statistics

Why are you still using the deprecated 'analyze index' command? You should be using dbms_stats.gather_index_stats() to generate index statistics. You should also be using dbms_stats.gather_table_stats() in place of 'analyze table', and should you use CASCADE=TRUE in the parameter list to gather_table_stats() you'll also generate your index statistics.

> and then running the validate structure but still nothing.

Why do you insist upon executing 'analyze index .. validate structure;'? What do you think this accomplishes other than validating an already valid index?

> anyone know why?

The question is why are you *not* using the dbms_stats package?

> Thanks,

David Fitzjarrell Received on Fri Jan 20 2006 - 12:15:10 CST