| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Query performance issue |
| Date: | 2024-10-22 20:47:11 |
| Message-ID: | 7fd675e06f99fc29f9c7c738b1d688c53f4f4f06.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2024-10-22 at 13:06 -0700, David G. Johnston wrote:
> On Tue, Oct 22, 2024 at 1:01 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
> > On Tue, Oct 22, 2024 at 3:02 PM Greg Sabino Mullane <htamfids(at)gmail(dot)com> wrote:
> > > * Don't use the "FROM table1, table2, table3" syntax but use "FROM table1 JOIN table2 ON (...) JOIN table3 ON (...)
> >
> > Why?
>
> Readability is improved when done correctly; and you need to know it for outer joins anyway, so consistency.
Also, you cannot accidentally forget a join condition.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yudhi s | 2024-10-22 21:23:59 | Re: Query performance issue |
| Previous Message | yudhi s | 2024-10-22 20:36:18 | Re: Query performance issue |