在联接表上使用MAX的SQL性能

我正在使用SQL Server 2008R2

我希望您对以下两个SQL语句的性能和最佳实践的看法。

select 
* 
from BcpSample1 
where dataloadid = (select MAX(id) from LoadControl_BcpSample1 where Status = 'completed') 

和

 select 
 a.* 
 from CiaBcpSample1 a
 inner join (select ActiveDataLoadId = MAX(id) from LoadControl_BcpSample1 where Status = 'completed') as t
 on a.DataLoadId = t.ActiveDataLoadId

我在SQLServerStudio中尝试了查询计划,但在运行两次后,两者都返回显示相同的查询计划。

谢谢