Re: Index Advisor question

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.