Linos <i...@linos.es> writes: > i am having any problems with performance of queries that uses CTE, can > the > join on a CTE use the index of the original table?
CTEs act as optimization fences. This is a feature, not a bug. Use them when you want to isolate the evaluation of a subquery. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance