Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 5546 invoked from network); 3 Apr 2009 21:28:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Apr 2009 21:28:21 -0000 Received: (qmail 2223 invoked by uid 500); 3 Apr 2009 21:28:21 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 2197 invoked by uid 500); 3 Apr 2009 21:28:21 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 2189 invoked by uid 99); 3 Apr 2009 21:28:21 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Apr 2009 21:28:21 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [68.142.206.43] (HELO n16.bullet.mail.mud.yahoo.com) (68.142.206.43) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 03 Apr 2009 21:28:12 +0000 Received: from [209.191.108.97] by n16.bullet.mail.mud.yahoo.com with NNFMP; 03 Apr 2009 21:27:51 -0000 Received: from [68.142.201.67] by t4.bullet.mud.yahoo.com with NNFMP; 03 Apr 2009 21:27:50 -0000 Received: from [127.0.0.1] by omp419.mail.mud.yahoo.com with NNFMP; 03 Apr 2009 21:27:50 -0000 X-Yahoo-Newman-Id: 971946.3362.bm@omp419.mail.mud.yahoo.com Received: (qmail 65968 invoked from network); 3 Apr 2009 21:27:50 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=CgEPKl3OuquurQ0pvFOLuJykjYqZ9k1HiqUfJIW6VGTHHrcH5G4ZBqcdHmqAuYkMOcHvl09fWctBsV8nDDjBfl9sevdSH7O6sJVJuk9jzrihAgrKTLdk/deh4z5ztffAjUtC/UKy/dm3Vp9oloHch1mPPpyzEKWNWQElkrnKTOA= ; Received: from unknown (HELO ?192.168.1.103?) (mikem_app@71.131.176.63 with plain) by smtp104.sbc.mail.sp1.yahoo.com with SMTP; 3 Apr 2009 21:27:49 -0000 X-YMail-OSG: 3gHQCsAVM1npV6sp8SpzLp7fXCpQHO5PEfRJhYPmeeNK7kN2rVrPMXhbzC8iCKHAjZDNezozRcNWGPpBYMBHfxnfOhTw_RH3kdTtXuRcOkSmiWiHRffuyJnqPrN3t9C3uRMPySqVBx6DkV.omf07cIM9MBf.EM_avo.nJZAcaldiZsFmMfmxNzLwuSG2Bh1Zux4VdJk_gutFb.uvXln2O77eBlxIUKnXkPc94tm17CNJJpeXbdXG8PzSlWIkkfpPpCzF9zTOmtVBAJc- X-Yahoo-Newman-Property: ymail-3 Message-ID: <49D67F56.1060907@sbcglobal.net> Date: Fri, 03 Apr 2009 14:27:50 -0700 From: Mike Matrigali User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: optimizer and left outer joins Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org if my multi table query only includes a series of left outer joins, does this force the optimizer to only choose that order of tables, unlike a regular join where it will consider various orders? /mikem