Re: Index Advisor question

["franz400" <franz400@xxxxxxx>]

Go back to V7 Infocenter and search Index Statistics   (I tried google but 
it is confused by the Infocenter Index...)
Jim

----- Original Message ----- 
From: "Mike Cunningham" <mike.cunningham@xxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, June 11, 2013 4:00 PM
Subject: Index Advisor question


> Does anyone know what it means when the Index Advisor shows "Source for 
> statistics" as the Reason Advised? This site 
> http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/index.jsp does not show 
> that as a valid value for the column.  We are getting this on 7 of our top 
> 10 "most expensive" advised indexes. When we look at the existing indexes 
> the index the advisor thinks should be created already exists.
>
>
> And part two..... is there an easy way to find indexes that exist but are 
> not used very often?  Index Advisor does a great job of telling me ones 
> that should be created but I think we have existing ones that never get 
> used and just add overhead
>
> Thanks
>
>
> Mike Cunningham
> Pennsylvania College of Technology
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.