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.