Terminology definitions/meaning

Started by Chris Velevitchover 18 years ago2 messagesgeneral
Jump to latest
#1Chris Velevitch
chris.velevitch@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Chris Velevitch (#1)
Re: Terminology definitions/meaning

"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