阅读背景:

关联查询与SQL Server中的内部连接性能

来源:互联网 

let's say that you want to select all rows from one table that have a corresponding row in another one (the data in the other table is not important, only the presence of a corresponding row is important). From what I know about DB2, this kinda query is better performing when written as a correlated query with a EXISTS clause rather than a INNER JOIN. Is that the same for SQL Server? Or doesn't it make any difference whatsoever?let's say that you want to select all rows from




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: