× 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.



Charles,

I am seeing those columns. The path you described is not quite the same as
what I see.

Databases > Database name > Schemas > named Schema > Tables.

Within the list of tables displayed Right click on a table name and select
"Show Indexes"

HTH

Jim

On Thu, Mar 26, 2009 at 12:14 PM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote:

According to Infocenter:

Determining unnecessary indexes

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
--
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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.