Re: Help with complex SQL statement

[Jeff Young <cooljeff913@xxxxxxxxx>]

Thanks Mike.
I already did that, and have created the index that the advisor recommended,
The query is using that index.
 
Jeff Young 
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3 
  
 





----- Original Message ----
From: Mike <koldark@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, October 30, 2008 2:16:17 PM
Subject: Re: Help with complex SQL statement

Run the statement in debug mode in interactive SQL and see if the optimizer
suggests a new index/logical.

If you aren't sure what I just said, on the green-screen do the following:
1. STRDBG
2. STRSQL
3. Run your statement, then exit out.
4. DSPJOBLOG
5. View the details of the messages (F10)
6. Look at the messages between STRSQL and the end.

I forget which message it is, but one of them may give you a suggested index
that should be created. Create the index, and you should see some increase
in speed.