Home Forums SQL Server 2012 SQL 2012 - General Explain the execution of a cte RE: Explain the execution of a cte
er.mayankshukla
SSCarpal Tunnel
Points: 4190
More actions
December 27, 2017 at 5:35 am
#1973558
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.