<!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性能优化
5星 · 超过95%的资源 需积分: 10 162 浏览量
2009-08-14
23:17:38
上传
评论
收藏 1.95MB RAR 举报 
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阅读起来不方便。
