From: Joshua D. Drake <jd@commandprompt.com>
To: J@Planeti.Biz
Cc: pgsql-performance@postgresql.org
Subject: Re: Query optimization with X Y JOIN
Date: Thu, 26 Jan 2006 08:34:11 -0800
Message-ID: <43D8FA03.304@commandprompt.com> (raw)
In-Reply-To: <008001c62295$156b8fc0$0d310d05@fatchubby>
References: <786c2f6d0601260206k2201a548p48af7c7fc085d3b2@mail.gmail.com>
<005d01c6228f$3772dca0$0d310d05@fatchubby>
<43D8F4FD.4040703@modgraph-usa.com>
<008001c62295$156b8fc0$0d310d05@fatchubby>
J@Planeti.Biz wrote:
> If I want my database to go faster, due to X then I would think that
> the issue is about performance. I wasn't aware of a paticular
> constraint on X.
>
> I have more that a rudementary understanding of what's going on here,
> I was just hoping that someone could shed some light on the basic
> principal of this JOIN command and its syntax. Most people I ask,
> don't give me straight answers and what I have already read on the web
> is not very helpful thus far.
What you are looking for is here:
http://sqlzoo.net/
It is an excellent website that discusses in depth but at a tutorial
style level how and what SQL is and how to use it. Including JOINS.
FYI, a JOIN is basically a FROM with an integrated WHERE clause. That is
a very simplified description and isn't 100% accurate
but it is close. I strongly suggest the website I mentioned above as it
will resolve your question.
Joshua D. Drake
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jd@commandprompt.com, J@Planeti.Biz, pgsql-performance@postgresql.org
Subject: Re: Query optimization with X Y JOIN
In-Reply-To: <43D8FA03.304@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox