Re: Embedded SQL Logical file use

["Mark Allen" <scprideandms@xxxxxxxxx>]

check the archives , seems there weas a discussion while back on a setting
for the Optimizer to "fix" this?

On 3/29/06, Kyle Collie <kcollie@xxxxxxxxx> wrote:
>
> We have an SQLRPG module that is opening a cursor based on a S/O
> logical. Everytime the program is run the query optimizer is checking
> for a better file to use and is eventually just coming back and using
> the initial S/O logical that we specified in the select statement. Is
> there a way to force the logical and prevent that processing time that
> is wasted when it tries to find a better index?
>
> The time it takes up is about 1 minute 20 seconds.
>
> Thanks in advance,
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>