What would be the best way of evaluating the performance of an inner query?
say you have something like
SELECT Key, sum() , sum() max()
into #table
from
(select key, case(), case() case()
union
select key()case, case(), case()
) as InnerQuery
group by key
say you have concerns of the innerquery could be done better, would doing a select into temp table from the inner query be a reflection of the performance in this instance? or is the no true way of evaluating it?