• Yes the plans are different and with select count(1) I do not see other columns being pulled up.
    That is my question, whether the execution of the query underlying cte depends on the way cte is queried.