Re: Determining unnecessary indexes

[Jim Essinger <dilbernator@xxxxxxxxx>]

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.