Re: Re: query optimizer, debug and access path suggestion

Rick,

You might try Optimize( *FirstIO ) and see what effect that has on it. It's a 
lot more likely to use an existing access path that way, and if you time it 
versus Optimize( *AllIO ) you may see the actual difference in cost between the 
two choices.

Dave Shaw
Simpsonville, SC
> 
> From: rick.baird@xxxxxxxxxxxxxxx
> Date: 2003/10/20 Mon PM 02:50:14 EDT
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: Re: query optimizer, debug and access path suggestion
> 
> G,
> 
> waiting shouldn't be a problem, since the logical join is the only other 
> access path other than the physical keys over either of the files.
> 
> but, it did consider the join access path and rejected it.
> 
> -------original message------------
> 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."
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>