On 26-Nov-2014 09:50 -0600, Mike Cunningham wrote:
Index Advisor will tell me when the database is creating a dynamic
index and provides data that helps me decide where I might need to
create a permanent index. Is there anything that would tell me where
I have a permanent index that is not being used anymore?

IIRC many releases ago, the Last Used Date and Days Used Count for the Member object that /owns/ the Access Path gets updated when that permanent AccPth is chosen to implement a query. Thus the Display File Description (DSPFD) for *MBR information would include an indication of the usage. A SQL catalog VIEW implemented as a Table Function that presents similar information, probably the Partition statistics, likely expose that same information.

Mike Cunningham
PA Colelge of Technology

If the above is a stored /signature/ text, might best consider spell-checking :-) optionally also insert before that text, a line\record with the conventional /signature delimiter/ consisting of only: dash, dash, space

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].