Re: join query performance
Chris <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <[email protected]> |
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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-php