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.