Re: Partitioned Index & Index_stats - how-to - no-one has an idea?

Hi There,

Sorry if this time the question was not clear at all. The fact is a use a web acces to post and it shows the postings as correlated even if the subject is different, so I did not thought to repeate the former question.

My problem was to be able to read in the index_stats table the results for a single partition of a partitioned index once I run "validate index index_name"
The answer was simple just use the extende name: "validate index index_name (partition_name)"

thanks
Fabrizio

"Andras Kovacs" <andkovacs_at_yahoo.com> wrote in message news:412ebb69.0308250401.758f2781_at_posting.google.com

> You question isn't clear.
> Statistics are always important on tables and indexes.
> If you have several indexes on your table, Oracle has to choose an
> index for your query. The choice will be based on the information
> available. If no stats are available Oracle might choose the bad
> index.

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG