Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 22516 invoked from network); 21 May 2010 07:15:55 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 21 May 2010 07:15:55 -0000 Received: (qmail 74665 invoked by uid 500); 21 May 2010 07:15:55 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 74443 invoked by uid 500); 21 May 2010 07:15:53 -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 74436 invoked by uid 99); 21 May 2010 07:15:52 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 May 2010 07:15:52 +0000 X-ASF-Spam-Status: No, hits=-2.8 required=10.0 tests=AWL,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.18.6.21] (HELO gmp-eb-inf-1.sun.com) (192.18.6.21) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 May 2010 07:15:44 +0000 Received: from fe-emea-09.sun.com (gmp-eb-lb-1-fe1.eu.sun.com [192.18.6.7] (may be forged)) by gmp-eb-inf-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id o4L7FMWa023307 for ; Fri, 21 May 2010 07:15:22 GMT MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) id <0L2R00B00CUGWA00@fe-emea-09.sun.com> for derby-dev@db.apache.org; Fri, 21 May 2010 08:15:11 +0100 (BST) Received: from [129.159.112.134] ([unknown] [129.159.112.134]) by fe-emea-09.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) with ESMTPSA id <0L2R00EXDDH9Z930@fe-emea-09.sun.com> for derby-dev@db.apache.org; Fri, 21 May 2010 08:15:11 +0100 (BST) Date: Fri, 21 May 2010 09:15:09 +0200 From: Knut Anders Hatlen Subject: Re: Finding all possible steps in a query? In-reply-to: Sender: Knut.Hatlen@Sun.COM To: derby-dev@db.apache.org Message-id: <4BF632FD.3090906@sun.com> References: User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US; rv:1.9.1.9) Gecko/20100318 Lightning/1.0b1 Thunderbird/3.0.4 On 05/21/10 05:05 AM, Nirmal Fernando wrote: > Hi All, > > I would like to know all possible ways that can be happened when a > query get executed such as (Natural Join, Hash Join, Sort etc.). Is > there any Derby doc that I can refer regarding this matter? > The tuning guide covers most of the access methods and join strategies in the sections under "Performance and optimization" found here: http://db.apache.org/derby/docs/dev/tuning/ctunoptimz23977.html -- Knut Anders