Re: CTE vs Subquery

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.