You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Nirmal Fernando <ni...@gmail.com> on 2010/05/21 05:05:02 UTC
Finding all possible steps in a query?
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?
Thank you.
--
Best Regards,
Nirmal
C.S.Nirmal J. Fernando
Department of Computer Science & Engineering,
Faculty of Engineering,
University of Moratuwa,
Sri Lanka.
Re: Finding all possible steps in a query?
Posted by Nirmal Fernando <ni...@gmail.com>.
Thanks Eranda and Knut !!
On Fri, May 21, 2010 at 12:45 PM, Knut Anders Hatlen
<Kn...@sun.com> wrote:
> 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
>
>
--
Best Regards,
Nirmal
C.S.Nirmal J. Fernando
Department of Computer Science & Engineering,
Faculty of Engineering,
University of Moratuwa,
Sri Lanka.
Re: Finding all possible steps in a query?
Posted by Knut Anders Hatlen <Kn...@Sun.COM>.
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
Re: Finding all possible steps in a query?
Posted by Eranda Sooriyabandara <er...@gmail.com>.
Hi Nirmal,
You can find all the combinations in JUNIT tests.
Thanks
Eranda
On Fri, May 21, 2010 at 8:35 AM, Nirmal Fernando <ni...@gmail.com>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?
>
> Thank you.
>
>
> --
> Best Regards,
> Nirmal
>
> C.S.Nirmal J. Fernando
> Department of Computer Science & Engineering,
> Faculty of Engineering,
> University of Moratuwa,
> Sri Lanka.
>