Re: imbedded sql index suggestions

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Yes, first check out the database tooling in ACS.  It replaces 90% of what was in the old iNavigator database and does it (IMHO) better.  

The performance section of Navigator also has some tooling but not as good as ACS. 
Jim Oberholtzer
Agile Technology Architects



> On Sep 4, 2025, at 11:42 AM, eric bothes <iseriesstuff@xxxxxxxxx> wrote:
>
> We are using a lot more sqlrpgle processes. i know when im in debug mode i can see suggestions of what indexes to build. is there something that will tell me across all applications using embedded sql which suggested access paths should be built?
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.