Skip site navigation (1) Skip section navigation (2)

Re: join query performance

From: Chris <dmagick(at)gmail(dot)com>
To: petchimuthu lingam <spmlingam(at)gmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: join query performance
Date: 2008-03-09 23:42:33
Message-ID: 47D475E9.1010709@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-php
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/

In response to

pgsql-performance by date

Next:From: Miguel ArrozDate: 2008-03-10 02:21:39
Subject: UPDATE 66k rows too slow
Previous:From: Heikki LinnakangasDate: 2008-03-08 20:25:09
Subject: Re: Joins and DELETE FROM

pgsql-php by date

Next:From: John CartwrightDate: 2008-03-10 17:37:51
Subject: pg_connect fails, pgsql works
Previous:From: petchimuthu lingamDate: 2008-03-08 05:01:53
Subject: join query performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group