Linos <info(at)linos(dot)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. Usethem when you want to isolate the evaluation of a subquery.
regards, tom lane