[4167] in sapr3-soft
Re: Nested SELECT vs Single Array Fetch...
daemon@ATHENA.MIT.EDU (Christopher Bowen)
Tue Sep 14 01:37:28 1999
To: sapr3-soft@MIT.EDU
Date: 8 Sep 1999 07:36:41 -0500
From: "Christopher Bowen" <christopher.t.bowen@worldnet.att.net> (by way of SAP Moderator <sap-request@realtimeusa.com>)
Message-Id: <7r5l8p$omd@nexus.netconcepts.com>
Nested Selects will almost always give you the worst performance of any of
the above.
When using the INNER JOIN you will get two statements sent to the database,
but the underlying code is generally much more efficient then what a
typical ABAP programmer would code.
