Re: Query performance issue

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: 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:06:20
Message-ID: CAKFQuwbV33pOEdayvCaOrgm+qYfVgpnTr8KP-katfxnDfQ+cQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:
> [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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message yudhi s 2024-10-22 20:36:18 Re: Query performance issue
Previous Message Ron Johnson 2024-10-22 20:00:50 Re: Query performance issue