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/
--
Sent via pgsql-php mailing list (pgsql-php@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php
