Re: query optimizer, debug and access path suggestion

Rick, have you tried OPTALLAP(*YES) on the OPNQRYF command?  This will
"Force the query optimizer to ignore the internal timeout value and
consider all the available access paths over all the files in the query.
Note that if there are a large number of access paths over the files it
may take a long time to optimize the query."

HTH, 
GA

--- rick.baird@xxxxxxxxxxxxxxx wrote:
> 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



__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com