Re: CTE vs Subquery
От
Tom Lane
Тема
Re: CTE vs Subquery
Дата
Msg-id
24672.1319561025@sss.pgh.pa.us
Ответ на
CTE vs Subquery (Linos)
Список
Дерево обсуждения
CTE vs Subquery Linos <info@linos.es>
Re: CTE vs Subquery Tom Lane <tgl@sss.pgh.pa.us>
Re: CTE vs Subquery Linos <info@linos.es>
Re: CTE vs Subquery Merlin Moncure <mmoncure@gmail.com>
Re: CTE vs Subquery Linos <info@linos.es>
Re: CTE vs Subquery Merlin Moncure <mmoncure@gmail.com>
Re: CTE vs Subquery Linos <info@linos.es>
Linos 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
В списке pgsql-performance по дате отправления
