Ticket #29695
Question
I added a couple tables and created some indexes on the AS400. m-Power isn't using them according to the DB Performance suggested indexes. Normally you don't want to create too many indexes especially over large files because of the overhead on the system to manage them. m-Power is suggesting the creation of 6 indexes for just one file that's used in the report (IDCASE00).
Answer
The suggested indexes you see here are just m-Power's recommendations on possible indexes you may want to create. Clicking the plus icon will create that index for you, and the suggestion will have a check mark next to it to indicate it's been created on your database. Now if you have created your own indexes on the AS/400 outside of these suggestions, they will be utilized in the scenarios you would expect, as indexes and their use are nothing inherent to m-Power but all controlled by your AS/400 database. Something else to keep in mind is you won't be able to visually see from m-Power when running the app with debug or in the logs that the application query is utilizing an index. Here's some docs that discuss the built in tool for creating indexes, if you'd like to check them out: https://www.mrc-productivity.com/docs/general/improving-database-performance https://www.mrc-productivity.com/docs/m-power-admin/performance-considerations Let me know if you have any other questions whatsoever that I can answer for you.
Asked on November 14, 2019