This can give some information. Best is to use a combination of the tools in Access Client Solutions, as others have suggested a couple of.

In ACS is the SQL Performance Center - you can see SQL statements that were used in jobs - then you can run Visual Explain over the statement, VE will give you ever so much more information than STRDBG can. And Index Adviser was suggested - you should not automatically create them all, every index you create means more time to execute database I/O, since the index has to be updated for inserts, writes, updates, deletes, all that.

If you don't have ACS, many of the tools are available in the previous Client Access or Access for IBM i, in Navigator there you will see several actions you can take, in a section near the bottom.


On 1/31/2022 8:40 AM, Peter Colpaert wrote:
I think you can run your program in debug (STRDBG) and then view the temp
indexes in your joblog.

Peter Colpaert


Op ma 31 jan. 2022 om 15:39 schreef Sean Courtney <scourtney@xxxxxxxxxxx>:

Hello everyone,

maybe someone else also had similar issues.

Sometimes when I join tables in SQL a temporary index is built during

I tried to counteract this by adding new LF’s and indexes … sometimes it
works and sometimes it doesn’t…

Is there a way to find out how sql builds these indexes ??

If yes could someone please give we a quick update on how to find the index
definition. If I were to create these indexes permanently then I would

Improve runtime performance considerably ..

Mit freundlichen Grüßen / Kind regards / Bien à vous,


This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related

Help support by shopping at with our affiliate

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 by 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.