I think it would be useful to tell us for which version of SQL Server this question is corresponding. I am not sure that with the new query optimizer ( corresponding to SQL Server 2014 ) the answer is the same one than for SQL Server 2012 ( the differences seem important according a session I listened in Paris SQL Server Days 2 weeks ago ).

Have a nice day