Re: Using CTE vs temporary tables

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, Jul 11, 2018 at 9:30 AM, hmidi slim <hmidi.slim2@xxxxxxxxx> wrote:

Hi,

I have a big query that used about 15 cte and its execution time is acceptable. I'm trying to optimize my query because it contains about 150 lines of code and becomes hard to understand it and add new filter or condition easily.

I think to change some cte with temporary tables and using indexes. I found this answer about performance between CTE and temp tables:

https://dba.stackexchange.com/questions/78253/postgresql-common-table-expressions-vs-a-temporary-table

Any suggestion will be welcome.

​Consider views and functions too.

David J.