×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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 mailing list archive is Copyright 1997-2025 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
