RE: sqlrpgle select statements

[qsrvbas@xxxxxxxxxxxx]

rpg400-l-request@xxxxxxxxxxxx wrote:

>   3. AW: sqlrpgle select statements (HauserSSS)
>
>You should NEVER use a logical file in an SELECT-Statement!
>The query dispatcher that decices which query engine will be used, will
>reroute all SQL-Statements that use a logical file to the Classic Query
>Engine (CQE). This rerouting will cost up to 10% of performance.


Although I won't recommend specifying the LF name in a SELECT/FROM, this does 
bring up the question of why in the world _some_ SELECTs will run in a fraction 
of the time when an LF is named instead of the PF.

I would expect that the answer would be found within DB2 group PTFs, but I 
don't really know.

Tom Liotta