📄 如何让你的sql运行得更快 - gprime的专栏 - csdnblog.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0059)http://blog.csdn.net/gprime/archive/2007/07/13/1687930.aspx -->
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog</TITLE>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content=gprime,SQL,提高效率 name=keywords>
<META content=如何让你的SQL运行得更快 name=description>
<SCRIPT src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/jsframework.js"
type=text/javascript></SCRIPT>
<SCRIPT src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/tabber.js"
type=text/javascript></SCRIPT>
<SCRIPT src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/feedBackToolTips.js"
type=text/javascript></SCRIPT>
<LINK media=screen href="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/tabber.css"
type=text/css rel=stylesheet><LINK
href="http://profile.csdn.net/gprime/picture/1.ico" rel="Shortcut Icon"><LINK
media=all href="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/style.css"
type=text/css rel=stylesheet><LINK media=print
href="/skins/Cogitation/print.css" type=text/css rel=stylesheet><LINK title=RSS
href="http://blog.csdn.net/gprime/rss.aspx" type=application/rss+xml
rel=alternate>
<META content="MSHTML 6.00.2900.3199" name=GENERATOR></HEAD>
<BODY>
<FORM language=javascript id=Form1 name=Form1
onsubmit="javascript:return WebForm_OnSubmit();" action=1687930.aspx
method=post><INPUT id=__EVENTTARGET type=hidden name=__EVENTTARGET> <INPUT
id=__EVENTARGUMENT type=hidden name=__EVENTARGUMENT> <INPUT
id=" __VIEWSTATE" type=hidden name=__VIEWSTATE>
<SCRIPT type=text/javascript>
<!--
var theForm = document.forms['Form1'];
if (!theForm) {
theForm = document.Form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
// -->
</SCRIPT>
<SCRIPT type=text/javascript>
//<![CDATA[
var Anthem_FormID = "Form1";
//]]>
</SCRIPT>
<SCRIPT src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/WebResource.axd"
type=text/javascript></SCRIPT>
<SCRIPT
src="D:\book\数据库资料\如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files\WebResource(1).axd"
type=text/javascript></SCRIPT>
<SCRIPT type=text/javascript>
<!--
function WebForm_OnSubmit() {
if (typeof(ValidatorOnSubmit) == "function" && ValidatorOnSubmit() == false) return false;
return true;
}
// -->
</SCRIPT>
<DIV id=top>
<DIV>
<TABLE>
<TBODY>
<TR>
<TD class=HeaderTitles>
<H1><A class=headermaintitle id=Header1_HeaderTitle
href="http://blog.csdn.net/gprime/">gprime的专栏</A></H1>
<P id=tagline><IMG class=UserStatus id=imgTitleIsOnline alt=""
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/blank.gif"><SPAN
id=TopicAuthor
style="DISPLAY: none">gprime</SPAN></P></TD></TR></TBODY></TABLE></DIV>
<DIV class=HeaderBar>
<TABLE class=HeaderBar id=HeaderBar>
<TBODY>
<TR>
<TD class=HeaderBarTab noWrap> <A href="http://www.csdn.net/"
target=_blank>CSDN</A> | <A href="http://dev.csdn.net/"
target=_blank>技术中心</A> | <A id=Header1_MyLinks1_HomeLink
title=到聚合站点 href="http://blog.csdn.net/"
target=_blank>BLOG首页</A> | <A id=Header1_MyLinks1_PersonalHome
title="访问 gprime的专栏" href="http://blog.csdn.net/gprime/"
target=_blank>我的首页</A> | <A id=Header1_MyLinks1_MyArticles
title="查看 gprime的专栏 所有文章"
href="http://blog.csdn.net/gprime/MyArticles.aspx"
target=_blank>我的文章</A> | <A id=Header1_MyLinks1_MySpace
title="查看 gprime 的个人空间" href="http://hi.csdn.net/gprime/profile"
target=_blank><FONT color=red>我的空间</FONT></A> | <A
id=Header1_MyLinks1_ContactLink accessKey=9
href="http://blog.csdn.net/gprime/contact.aspx">联系作者</A> | <A
id=Header1_MyLinks1_HyperLink1
href="http://search.csdn.net/search_blog.asp"
target=_blank>搜索</A> | <A id=Header1_MyLinks1_Admin
href="http://writeblog.csdn.net/">写文章</A> <IMG id=Header1_BlueTab
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/BlueTabRight.jpg"
align=absMiddle border=0> </TD>
<TD class=HeaderBarTabBack noWrap width="100%">
<DIV class=BlogStatsBar>
<TABLE class=BlogStatsBar>
<TBODY>
<TR>
<TD width="100%"></TD>
<TD class=BlogStatsBar noWrap> 8篇原创: 0篇翻译: 11篇转载: 3854次点击:
4个评论: 0个Trackbacks
</TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></DIV><!-- check user online status 20070530 meizz -->
<SCRIPT type=text/javascript>Include("Csdn.Blog.UserOnline");</SCRIPT>
<SCRIPT type=text/javascript>Include("Csdn.Blog.ShowmeDataDeal");</SCRIPT>
</DIV>
<DIV id=leftmenu>
<H3>公告</H3>
<DIV id=News1_pnlMyResume><BR>
<H3>我的简历</H3>
<DIV id=job_csdn_net_sr></DIV>
<SCRIPT src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/gprime.aspx"></SCRIPT>
</DIV><SPAN id=SubscriptionList>
<H3 class=listtitle>订阅博客</H3>
<UL class=list>
<LI class=listitem><A href="http://blog.csdn.net/gprime/Rss.aspx"><IMG
alt=XML聚合 src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/xml.gif"
border=0></A> <A href="http://feeds.feedsky.com/csdn.net/gprime"
target=_blank><IMG alt=FeedSky
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/feedsky.gif" border=0></A>
<LI class=listitem><A
href="http://www.xianguo.com/subscribe.php?url=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到鲜果
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_xianguo.jpg" border=0></A>
<LI class=listitem><A
href="http://fusion.google.com/add?feedurl=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到Google
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_google.gif" border=0></A>
<LI class=listitem><A
href="http://www.zhuaxia.com/add_channel.php?url=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到抓虾
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_zhuaxia.gif" border=0></A>
<LI class=listitem><A
href="http://www.bloglines.com/sub/http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到BlogLines
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_bloglines.gif"
border=0></A>
<LI class=listitem><A
href="http://add.my.yahoo.com/rss?url=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到Yahoo
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_yahoo.gif" border=0></A>
<LI class=listitem><A
href="http://rss.gougou.com/find_rss.jsp?url=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到GouGou
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_gougou.gif" border=0></A>
<LI class=listitem><A
href="http://www.pageflakes.com/subscribe.aspx?url=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到飞鸽
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_pageflakes.gif"
border=0></A>
<LI class=listitem><A
href="http://www.rojo.com/add-subscription?resource=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到Rojo
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_rojo.gif" border=0></A>
<LI class=listitem><A
href="http://www.newsgator.com/ngs/subscriber/subfext.aspx?url=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到newsgator
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_newsgator.gif"
border=0></A>
<LI class=listitem><A
href="http://www.netvibes.com/subscribe.php?url=http://blog.csdn.net/gprime/Rss.aspx"
target=_blank><IMG alt=订阅到netvibes
src="如何让你的SQL运行得更快 - gprime的专栏 - CSDNBlog.files/rss_netvibes.gif"
border=0></A></LI></UL></SPAN><SPAN id=RecentVisitors></SPAN>
<H3 class=listtitle>文章</H3>
<UL class=list>
<LI class=listitem><A
href="http://blog.csdn.net/gprime/category/318472.aspx">Office</A><A
href="http://blog.csdn.net/gprime/category/318472.aspx/rss">(RSS)</A>
<LI class=listitem><A
href="http://blog.csdn.net/gprime/category/311865.aspx">Visual Studio</A><A
href="http://blog.csdn.net/gprime/category/311865.aspx/rss">(RSS)</A>
<LI class=listitem><A
href="http://blog.csdn.net/gprime/category/318471.aspx">Web服务</A><A
href="http://blog.csdn.net/gprime/category/318471.aspx/rss">(RSS)</A></LI></UL>
<H3 class=listtitle>收藏</H3>
<UL class=list></UL>
<H3 class=listtitle>相册</H3><!--category title-->
<UL class=list></UL>
<H3 class=listtitle>存档</H3>
<UL class=list>
<LI><A href="http://blog.csdn.net/gprime/archive/2007/07.aspx">2007年07月(8)</A>
<LI><A
href="http://blog.csdn.net/gprime/archive/2007/06.aspx">2007年06月(4)</A></LI></UL><SPAN
id=Anthem_RecentComments_ltlComments__><SPAN id=RecentComments_ltlComments>
<H3 class=listtitle>最近评论</H3>
<UL class=list>
<LI class=listitem>allenzhao:<A title=点击查看《回复:如何让你的SQL运行得更快》
href="http://blog.csdn.net/gprime/archive/2007/07/13/1687930.aspx#738545">测试环境:
主机:HP LH II---- 主频:330MHZ---- 内存:128兆----
<BR>操作系统:Operserver5.0.4----<BR>数据库:Sybase11.0.3<BR>机器好撇哟~~</A>
<LI class=listitem>SimonYeung:<A title=点击查看《回复:如何让你的SQL运行得更快》
href="http://blog.csdn.net/gprime/archive/2007/07/13/1687930.aspx#738004">MARK</A>
<LI class=listitem>zkdemon:<A title=点击查看《回复:如何让你的SQL运行得更快》
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -