Postgres Pro
Downloads
Home   >   mailing lists

Re: Query performance issue - Mailing list pgsql-general

From David G. Johnston
Subject Re: Query performance issue
Date
Msg-id CAKFQuwbV33pOEdayvCaOrgm+qYfVgpnTr8KP-katfxnDfQ+cQg@mail.gmail.com
Whole thread Raw
In response to Re: Query performance issue  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Query performance issue
List pgsql-general
Tree view
On Tue, Oct 22, 2024 at 1:01 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Tue, Oct 22, 2024 at 3:02 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:
[snip] 
* 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.

David J.

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Query performance issue
Next
From: yudhi s
Date:
Subject: Re: Query performance issue