×
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.
You can easily determine which indexes are being used for query optimization.
Before V5R3, it was difficult to determine unnecessary indexes. Using
the Last Used Date was not dependable, as it was only updated when the
logical file was opened using a native database application (for
example, in an RPG application). Furthermore, it was difficult to find
all the indexes over a physical file. Indexes are created as part of a
keyed physical file, a keyed logical file, a join logical file, an SQL
index, a primary key or unique constraint, or a referential
constraint. However, you can now easily find all indexes and retrieve
statistics on index usage as a result of new V5R3 iSeries® Navigator
and i5/OS® functionality. To assist you in tuning your performance,
this function now produces statistics on index usage as well as index
usage in a query.
To access this through the iSeries Navigator, navigate to: Database >
Schemas > Tables. Right-click your table and select Show Indexes
However, for showing indexes brings up a window lising the indexes,
but I don't see the following fields describe on the infocenter page
Last Query Use
States the timestamp when the index was last used to retrieve data
for a query.
Last Query Statistic Use
States the timestamp when the index was last used to provide
statistical information.
Query Use Count
Lists the number of instances the index was used in a query.
Query Statistics Use
Lists the number of instances the index was used for statistical
information.
Right Clicking on an index and selecting description gives me a pop-up
with 3 tabs, "Access Path", "Usage", and "Details", none of which have
the fields mentioned above.
Does anybody see these on your version of Client Access?
I'm running CA v5r4 to a v5r4 box.
Thanks!
Charles Wilt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.