El 25/10/11 18:43, Tom Lane escribió:
> Linos <info@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
>
The truth it is that complex queries seems more readable using them (maybe a
personal preference no doubt).
Do have other popular databases the same behavior? SQL Server or Oracle for example?
Regards,
Miguel Ángel.