<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
<html xml:lang="en" xmlns="http://www.w3.org/1999/xhtml" lang="en"><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Craig Freedman's SQL Server Blog : Merge Join</title>
<meta name="keywords" content="Joins">
<meta name="description" content="In this post, I’ll describe the second physical join operator: merge join (MJ). Unlike the nested loops join which supports any join predicate, the merge join requires at least one equijoin predicate. Moreover, the inputs to the merge join must be sorted">
<meta name="GENERATOR" content="CommunityServer 2.1 SP1 (Build: 61025.2)">
<link rel="pingback" href="http://blogs.msdn.com/craigfr/pingback.aspx">
<link rel="stylesheet" href="20060803_files/style.css" type="text/css" media="screen">
<link rel="stylesheet" href="20060803_files/print.css" type="text/css" media="print">
<link rel="shortcut icon" type="image/ico" href="http://blogs.msdn.com/favicon.ico">
<link rel="alternate" type="application/rss+xml" title="Craig Freedman's SQL Server Blog (RSS 2.0)" href="http://blogs.msdn.com/craigfr/rss.xml">
<link rel="alternate" type="application/atom+xml" title="Craig Freedman's SQL Server Blog (Atom 1.0)" href="http://blogs.msdn.com/craigfr/atom.xml">
<link rel="alternate" type="application/rss+xml" title="Merge Join Comment RSS (RSS 2.0)" href="http://blogs.msdn.com/craigfr/commentrss.aspx?PostID=687584">
<script src="20060803_files/global.js" type="text/javascript"></script>
</head><body>
<form name="aspnetForm" method="post" action="/craigfr/archive/2006/08/03/merge-join.aspx" id="aspnetForm">
<div>
<input name="__EVENTTARGET" id="__EVENTTARGET" value="" type="hidden">
<input name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" type="hidden">
<input name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTMyNjg0MDc1MWQYAQUeX19Db250cm9sc1JlcXVpcmVQb3N0QmFja0tleV9fFgEFI2N0bDAwJF8kY3RsMDAkXyRicyRfJHdzJF8kU2VhcmNoQm94rkRXbV1z5ohWybmugg6l5bfTy3M=" type="hidden">
</div>
<script type="text/javascript">
//<![CDATA[
var theForm = document.forms['aspnetForm'];
if (!theForm) {
theForm = document.aspnetForm;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>
</script>
<script language="javascript" type="text/javascript" src="20060803_files/Telligent_Modal.js"></script><script language="javascript" type="text/javascript">
// <![CDATA[
Telligent_Modal.Configure('/utility/loading.htm',['Modal'],['ModalTitle'],['ModalClose'],['ModalContent'],['ModalFooter'],['ModalResize'],['ModalMask'],100);
// ]]>
</script><script type="text/javascript" src="20060803_files/ratingcontrol.js"></script>
<div id="masthead">
<div id="welcome" align="right">
Welcome to MSDN Blogs
<a id="ctl00___ctl00___duw1_ac1___Login" href="http://blogs.msdn.com/login.aspx?ReturnUrl=%2fcraigfr%2farchive%2f2006%2f08%2f03%2fmerge-join.aspx">Sign in</a> | <a id="ctl00___ctl00___duw1_ac1___Register" href="http://blogs.msdn.com/user/CreateUser.aspx?ReturnUrl=/craigfr/archive/2006/08/03/merge-join.aspx">Join</a>
|
<a id="ctl00___ctl00___duw1_Faq1" href="http://blogs.msdn.com/languages/en-US/docs/faq.aspx">Help</a>
</div>
</div>
<div id="wrapper">
<div id="container">
<div id="header">
<div id="title">
<h1><a id="ctl00___ctl00___bth___BlogTitle" class="headermaintitle" href="http://blogs.msdn.com/craigfr/default.aspx">Craig Freedman's SQL Server Blog</a></h1>
<p id="tagline">A discussion of query processing, query execution, and query plans in SQL Server.</p></div>
</div>
<div id="contentwrapper">
<div id="sidebar-a">
<div id="BlogLinksSideBar">
<div id="WeblogLinks">
<h3>This Blog</h3>
<ul>
<li><a id="ctl00___ctl00___bs___wl___Aboutlink1" href="http://blogs.msdn.com/craigfr/about.aspx">About</a></li>
<li><a id="ctl00___ctl00___bs___wl___Contactlink1" href="http://blogs.msdn.com/craigfr/contact.aspx">Email</a></li>
</ul>
</div>
</div>
<div id="TasksSideBar">
</div>
<div id="SubscriptionsSideBar">
<div id="Subscriptions">
<h3>Syndication</h3>
<ul>
<li><a id="ctl00___ctl00___bs___bs___rss" href="http://blogs.msdn.com/craigfr/rss.xml">RSS 2.0</a></li>
<li><a id="ctl00___ctl00___bs___bs___atom" href="http://blogs.msdn.com/craigfr/atom.xml">Atom 1.0</a></li>
</ul>
</div>
</div>
<div id="SearchSideBar">
<h3>Search</h3>
<div id="Search">
<ul><li>
<input name="ctl00$_$ctl00$_$bs$_$ws$_$SearchBox" id="ctl00___ctl00___bs___ws___SearchBox" class="searchBox" onkeydown="KeyDownHandlerctl00___ctl00___bs___ws___SearchButton(event);" type="text"> <a id="ctl00___ctl00___bs___ws___SearchButton" href="javascript:__doPostBack('ctl00$_$ctl00$_$bs$_$ws$_$SearchButton','')">Go</a>
</li></ul>
</div>
</div>
<div id="TagSideBar">
<h3>Tags</h3>
<ul>
<ul class="SidebarTagCloud">
<li class="Tag1"><a href="http://blogs.msdn.com/craigfr/archive/tags/Aggregation/default.aspx" rel="tag">Aggregation</a></li>
<li class="Tag5"><a href="http://blogs.msdn.com/craigfr/archive/tags/Common+Table+Expressions/default.aspx" rel="tag">Common Table Expressions</a></li>
<li class="Tag5"><a href="http://blogs.msdn.com/craigfr/archive/tags/Conversions/default.aspx" rel="tag">Conversions</a></li>
<li class="Tag6"><a href="http://blogs.msdn.com/craigfr/archive/tags/Hints/default.aspx" rel="tag">Hints</a></li>
<li class="Tag3"><a href="http://blogs.msdn.com/craigfr/archive/tags/I_2F00_O/default.aspx" rel="tag">I/O</a></li>
<li class="Tag2"><a href="http://blogs.msdn.com/craigfr/archive/tags/Isolation+Levels/default.aspx" rel="tag">Isolation Levels</a></li>
<li class="Tag1"><a href="http://blogs.msdn.com/craigfr/archive/tags/Joins/default.aspx" rel="tag">Joins</a></li>
<li class="Tag3"><a href="http://blogs.msdn.com/craigfr/archive/tags/Parallelism/default.aspx" rel="tag">Parallelism</a></li>
<li class="Tag4"><a href="http://blogs.msdn.com/craigfr/archive/tags/Partitioned+Tables/default.aspx" rel="tag">Partitioned Tables</a></li>
<li class="Tag5"><a href="http://blogs.msdn.com/craigfr/archive/tags/Pivot+and+Unpivot/default.aspx" rel="tag">Pivot and Unpivot</a></li>
<li class="Tag6"><a href="http://blogs.msdn.com/craigfr/archive/tags/Ranking+Functions/default.aspx" rel="tag">Ranking Functions</a></li>
<li class="Tag5"><a href="http://blogs.msdn.com/craigfr/archive/tags/Rollup+and+Cube/default.aspx" rel="tag">Rollup and Cube</a></li>
<li class="Tag1"><a href="http://blogs.msdn.com/craigfr/archive/tags/Scans+and+Seeks/default.aspx" rel="tag">Scans and Seeks</a></li>
<li class="Tag3"><a href="http://blogs.msdn.com/craigfr/archive/tags/Subqueries/default.aspx" rel="tag">Subqueries</a></li>
<li class="Tag6"><a href="http://blogs.msdn.com/craigfr/archive/tags/Top/default.aspx" rel="tag">Top</a></li>
<li class="Tag2"><a href="http://blogs.msdn.com/craigfr/archive/tags/Updates/default.aspx" rel="tag">Updates</a></li>
</ul>
</ul>
</div>
<div id="NewsSideBar">
<h3>News</h3>
<div id="news">All postings on this blog are provided "AS IS" with no warranties, and confer no rights.
</div>
</div>
<div id="ArchiveSideBar">
<h3>Archives</h3>
<ul>
<li>
<a href="http://blogs.msdn.com/craigfr/archive/2009/04.aspx">April 2009 (1)</a>
</li>
<li>
<a href="http://blogs.msdn.com/craigfr/archive/2009/03.aspx">March 2009 (2)</a>
</li>
<li>
<a href="http://blogs.msdn.com/craigfr/archive/2009/02.aspx">February 2009 (1)</a>
</li>
<li>
<a href="http://blogs.msdn.com/craigfr/archive/2008/10.aspx">Octob
Sql Server——Sql性能优化 （697个子文件） 
style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB style.css 14KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB print.css 3KB共 697 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
zlg1692012-04-22不错，挺有用的，就是里面全是网页版的，没有大纲，阅读起来不是很方便。
lxyllsm2012-07-01嗯，阅读起来比较麻烦，内容还可以！- hanxueniao2012-06-28阅读起来不方便。
maizisyict
- 粉丝: 0
- 资源: 3
最新资源
- (源码)基于SimPy和贝叶斯优化的流程仿真系统.zip
- (源码)基于Java Web的个人信息管理系统.zip
- (源码)基于C++和OTL4的PostgreSQL数据库连接系统.zip
- (源码)基于ESP32和AWS IoT Core的室内温湿度监测系统.zip
- (源码)基于Arduino的I2C协议交通灯模拟系统.zip
- coco.names 文件
- (源码)基于Spring Boot和Vue的房屋租赁管理系统.zip
- (源码)基于Android的饭店点菜系统.zip
- (源码)基于Android平台的权限管理系统.zip
- (源码)基于CC++和wxWidgets框架的LEGO模型火车控制系统.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
