From: Chris <dmagick@gmail.com>
To: petchimuthu lingam <spmlingam@gmail.com>
Cc: pgsql-php@postgresql.org
Subject: Re: join query performance
Date: Mon, 10 Mar 2008 10:42:33 +1100
Message-ID: <47D475E9.1010709@gmail.com> (raw)
In-Reply-To: <cd233fc30803072101u47c47bd5y7547e536495d04c1@mail.gmail.com>
References: <cd233fc30803072007oa6f351vbbe611491aca6ed1@mail.gmail.com>
<cd233fc30803072101u47c47bd5y7547e536495d04c1@mail.gmail.com>
petchimuthu lingam wrote:
>
> In a select query i have used the join conditions, will it affect query
> performance.
>
> Explicitly I didn't used the join command, Will it make any difference.
It'll make sure you don't miss any join conditions between two tables so
it'll be helpful in that respect, I didn't read your whole query but
with a 7 table join it's very easy to miss doing a match on one or more
tables.
It shouldn't take more than a couple of minutes to rewrite your query
and find out the answers..
--
Postgresql & php tutorials
http://www.designmagick.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-performance@postgresql.org
Cc: dmagick@gmail.com, spmlingam@gmail.com, pgsql-php@postgresql.org
Subject: Re: join query performance
In-Reply-To: <47D475E9.1010709@gmail.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