Обсуждение: Terminology definitions/meaning

I'm trying to understand the explain output, but I can't find any
references to the meanings of the following terms:-

     merge join
     nested loop
     merge left join
     nested loop left join

I'm using 7.4.


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au

"Chris Velevitch" <chris.velevitch@gmail.com> writes:
> I'm trying to understand the explain output, but I can't find any
> references to the meanings of the following terms:-
>      merge join
>      nested loop
>      merge left join
>      nested loop left join

http://developer.postgresql.org/pgdocs/postgres/planner-optimizer.html

            regards, tom lane