If I repeat the same derived table 2 or 3 times in my SQL select statement, the execution plan looks like it executes the same select code several times.  Do CTEs make the execution plan more efficient in such cases or is it merely a (very) nice shorthand?