I agree .."It depends" .

Recently when I chekced the execution plan for a slow running query ..the CTE's were the one which were with more percentages.

The I/O cost was...