RE: sqlrpgle select statements

[Alan Shore <AlanShore@xxxxxxxx>]

One reason that I would recommend in using a(n) LF in a  SELECT/FROM, is
the SELECT/OMIT's within the DDS of the LF.  This might be the reason "why
in the world _some_ SELECTs will run in a fraction of the time when an LF
is named instead of the PF"


Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx


                                                                       
             qsrvbas@netscape.                                         
             net                                                       
             Sent by:                                                   To
             rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx           
             midrange.com                                               cc
                                                                       
                                                                   Subject
             03/01/2006 08:26          RE: sqlrpgle select statements  
             PM                                                        
                                                                       
                                                                       
             Please respond to                                         
              RPG programming                                          
              on the AS400 /                                           
                  iSeries                                              
             <rpg400-l@midrang                                         
                  e.com>                                               
                                                                       
                                                                       




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

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com


__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at
http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
--
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.