I think you can run your program in debug (STRDBG) and then view the temp
indexes in your joblog.
Op ma 31 jan. 2022 om 15:39 schreef Sean Courtney <scourtney@xxxxxxxxxxx>:
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 midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.