On Wed, Jul 11, 2018 at 9:30 AM, hmidi slim <hmidi.sl...@gmail.com> 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.

Reply via email to