| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Miguel Arroz | 2008-03-10 02:21:39 | UPDATE 66k rows too slow |
| Previous Message | Heikki Linnakangas | 2008-03-08 20:25:09 | Re: Joins and DELETE FROM |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Cartwright | 2008-03-10 17:37:51 | pg_connect fails, pgsql works |
| Previous Message | petchimuthu lingam | 2008-03-08 05:01:53 | join query performance |