CHOOSE and SELECT vs SQL

[fernando.olmos at hpa.com.au]

Is my statement below correct Joe, etc?

-----Original Message-----
From: Fernando Olmos 
Sent: Wednesday, 5 April 2006 2:45 PM
To: Peter Hofstaetter
Subject: RE: powerh-l Digest, Vol 11, Issue 8


I bet the CHOOSE statement equates to a INNER JOIN ON statement in SQL!
The SELECT RECORD IF equates to an INNER LEFT JOIN ON and the SELECT IF
does not use JOINS at all!

-----Original Message-----
From: Peter Hofstaetter 
Sent: Wednesday, 5 April 2006 2:42 PM
To: Fernando Olmos
Subject: FW: powerh-l Digest, Vol 11, Issue 8


Hi Fernando,

>From my experience, the choose on non index fields does get sent to
Oracle and there is a noticeable difference in speed to doing a choose
to using select table if, i.e. all chooses are converted to a where
clause sent to Oracle and all selects are done by Powerhouse after the
data has been sent back from Oracle.
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed.  If
you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************