From: J@Planeti.Biz
Message-ID: <005d01c6228f$3772dca0$0d310d05@fatchubby>
To: <pgsql-performance@postgresql.org>
References: <786c2f6d0601260206k2201a548p48af7c7fc085d3b2@mail.gmail.com>
Subject: Query optimization with X Y JOIN
Date: Thu, 26 Jan 2006 10:43:12 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_005A_01C62265.4E685720"

This is a multi-part message in MIME format.

------=_NextPart_000_005A_01C62265.4E685720
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hey guys, how u been. This is quite a newbie question, but I need to ask =
it. I'm trying to wrap my mind around the syntax of join and why and =
when to use it. I understand the concept of making a query go faster by =
creating indexes, but it seems that when I want data from multiple =
tables that link together the query goes slow. The slow is typically due =
to expensive nested loops. The reason is, all my brain understands is:

select
    tablea.data
    tableb.data
    tablec.data
from
    tablea
    tableb
    tablec
where
    tablea.pri_key =3D tableb.foreign_key AND
    tableb.pri_key =3D tablec.foreign_key AND...