经验显示,Inner Join 更快.
select a.* from a Inner Join b On a.Id=b.ID where b.name=@name
select a.* from a where exists(select id from b where id=a.id and name=@name)
经验显示,Inner Join 更快.
select a.* from a Inner Join b On a.Id=b.ID where b.name=@name
select a.* from a where exists(select id from b where id=a.id and name=@name)