On 1/21/13 9:41 AM, Tom E Stieger wrote:
Hope this helps.
1. Open System I navigator
2. Expand My AS/400 Connections
3. Expand the server you are connected to
4. Expand Databases
5. Right-Click on the database name for your system
6. Select Run SQL Scripts
7. Paste your SQL into the run SQL scripts
8. Select VisualExplain -> Explain
Hmm. I don't see "Run SQL Scripts."
But be that as it may, just running a STRSQL in the debugger, and
feeding it a hand-coded reconstruction of the generated SQL being run by
the application, got me some index suggestions that I implemented, and
that may have speeded some things up, just a bit.
--
JHHL
