Re: join query performance

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/