Re: Embedded SQL performance question.

Does the Logical have any select and omit criteria?

Joel
http://www.rpgnext.com


On Thu, 2003-11-13 at 19:34, Steve Cross wrote:
> Hi,
>  
> I have an embedded SQL statement in my RPG program
> 
> It's a typical select statement over a logical file. 
> 
> the where selections and the order by are against the 1st two primary key
> fields.
> 
> when I execute this statement using Interactive SQL it runs fine. quick
> response and debug says it chose the logical access path
> 
> when I run it in the RPG program the optimizer builds its own access path
> and takes 3 minutes to execute. 
> 
> the statements are identical.
> 
> what am I doing wrong.  I am running OS V5R2
> 
> Thanks in advance,
> Steve
> _______________________________________________
> 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.