query optimizer, debug and access path suggestion

[rick.baird@xxxxxxxxxxxxxxx]

Long story short - I'm running an opnqryf command over a joined logical of 
two really large files.

i tested it with debug running and found that, due to the complexity of 
the select statement, the query optimizer decided to build it's own join, 
rather than use the existing join, even though I used KEYFLD(*FILE) 

I got two access path suggestions, one on each file.

My question is, should I try to change the key fields of the join logical 
to match the keys suggested for the primary file, or do what the 
suggestion says and build the logicals suggested over both files?   fyi, 
the logical suggested for the secondary file contained only one field.

thanks,

rick