SQL Server如何选择执行哪种类型的联接 [英] how Sql server choose which type of join perform

问题描述

Sql服务器如何选择执行哪种连接类型....哈希连接，循环连接或合并连接.

以及哪种连接有效.

谢谢.

how Sql server choose which type of join perform....either hash join , loop join or merge join.

and which join is efficient.

Thanks.

推荐答案

本文将为您提供取决于"的想法-
http://www.sqlserverblogforum.com/2011 /10/merge-join-vs-hash-join-vs-nested-loop-join/ [

This article will give you an idea that ''it depends'' -
http://www.sqlserverblogforum.com/2011/10/merge-join-vs-hash-join-vs-nested-loop-join/[^].

请参阅下面的文章以低估联接

http://blog.sqlauthority.com/2009 /04/13/sql-server-introduction-to-joins-basic-of-joins/ [ http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example / [ ^ ]

如何最有效地联接两个表 [

Refer below article for understating joins

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/[^]

http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/[^]

How to most efficiently join two tables[^]

这篇关于SQL Server如何选择执行哪种类型的联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！