This is hard to tell because your description is too vague.

You could build both solutions, set the statistics on (set statistics time on; set statistics io on;

) and execute both solutions. Also look at the execution plans. The output of the statistics and the execution plan will give you information to choose the best option.