Postgres Pro
Downloads
Home   >   mailing lists

Re: CTE with JOIN of two tables is much faster than a regular query - Mailing list pgsql-general

From Ravi Krishna
Subject Re: CTE with JOIN of two tables is much faster than a regular query
Date
Msg-id 807123113.9511341.1534609514205@mail.yahoo.com
Whole thread Raw
In response to CTE with JOIN of two tables is much faster than a regular query  (<kpi6288@gmail.com>)
Responses AW: CTE with JOIN of two tables is much faster than a regular query
List pgsql-general
Tree view 
> What can I do to improve the performance of the regular query without using a CTE? 

Why do you care ?  When I find that I can write a SQL 3 different ways, I will go for the most
efficient one.  So why not accept the CTE version of this SQL.  Just curious.

pgsql-general by date:

Previous
From: Dmitri Maziuk
Date:
Subject: Re: vPgSql
Next
From:
Date:
Subject: AW: CTE with JOIN of two tables is much faster than a regular query