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
