Re: HowTo find out used (useful) and unused (usesless) indexes?

"DA Morgan" <damorgan@[EMAIL PROTECTED]
> schreef in bericht 
news:1208624947.696580@[EMAIL PROTECTED]
> Shakespeare wrote:
>
>> But an index may become useful over time, true?
>>
>> Shakespeare
>
> On that basis alone one could justify putting an index on every
> column of every table so I will respectfully disagree unless you
> write a very broad definition of "may."
>
> You need to understand your data and how it is being accessed.
> The extra overhead of an unused index is not value added.
>
> My recommendation would be to use the DBMS_STATS.SET.... procedures
> to see how queries will react to the expected future growth of both
> tables and indexes.
> -- 
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Wa****ngton
> damorgan@[EMAIL PROTECTED]
 (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

I was aiming at data with for example a 'year' column. This column could
be 
indexed by design, but in the first year (all records same value) this
index 
is not useful and won't be used. But on the first entry in the second year

it is useful to find entries of that year and so on. A script to remove or

disable unused indexes would remove/disable this index in the first year.

Shakespeare