?? oracle sql性能優化系列 (二)--acnow_net.htm
字號:
<HTML>
<HEAD>
<TITLE>ORACLE SQL性能優化系列 (二)--AcNow.Net</TITLE>
<META http-equiv=content-type content="text/html; charset=gb2312">
<STYLE type=text/css>
H1 {FONT-SIZE:24px;MARGIN:0px;}
TD,SELECT,INPUT {FONT-SIZE:12px;}
.l17 {LINE-HEIGHT:170%;WORD-WRAP:break-word;}
.l15 {LINE-HEIGHT:150%;}
.f7 {FONT-SIZE:7px;}
.f24 {FONT-SIZE:24px;}
.f14 {FONT-SIZE:14px;LINE-HEIGHT:130%}
A:link,A:visited { text-decoration:none;COLOR:#0000ff;}
A:active,A:hover { text-decoration:none;COLOR:#ff0000;}
A.a01:link,A.a01:visited {text-decoration:none;color:#07015B;}
A.a2:link,A.a2:visited {text-decoration:none;color:#07015B;}
</STYLE>
<SCRIPT language=JavaScript>
function doZoom(size){
document.getElementById('zoom').style.fontSize=size+'px'
}
</SCRIPT>
<SCRIPT language=JavaScript>
function doPrint(){
var str="<html>";
var article;
var css;
var strAdBegin="<!--NEWSZW_HZH_BEGIN-->";
var strAdEnd="<!--NEWSZW_HZH_END-->";
var strFontSize='【<A href="javascript:doZoom(16)">大</A> <A href="javascript:doZoom(14)">中</A> <A href="javascript:doZoom(12)">小</A>】'
var strdoPrint="doPrint()";
var strTmp;
css="<style>"
+"body{font-family:宋體}"
+"td,.f12{font-size:12px}"
+".f24 {font-size:24px;}"
+".f14 {font-size:14px;}"
+".title14 {font-size:14px;line-height:130%}"
+".l17 {line-height:170%;}"
+"</style>";
str += css;
str += '<meta http-equiv="content-type" content="text/html; charset=gb2312">';
str += "<body bgcolor=#ffffff topmargin=5 leftmargin=5 marginheight=5 marginwidth=5 onLoad='window.print()'>";
str += '<center><table width=600 border=0 cellspacing=0 cellpadding=0><tr><td height=34 width=150><a href=http://tech.acnow.net><img src=http://image.acnow.net/images/acnow_small.gif width=158 height=19 border=0></a></td><td valign=bottom><font color=#0000ff><a target="_blank" href="http://tech.acnow.net/Index.shtml"><font color=red>首頁</font></a> >> <a target="_blank" href="http://tech.acnow.net/Html/DataBase/index.shtml" >數據庫</a> >> <a target="_blank" href="http://tech.acnow.net/Html/DataBase/Oracle/index.shtml" >Oracle</a> >> 正文</font></td><td align=right valign=bottom><a href="javascript:history.back()">返回</a> <a href="javascript:window.print()">打印</a></td></tr></table>';
str += "<table width=600 border=0 cellpadding=0 cellspacing=20 bgcolor=#EDF0F5><tr><td>";
article=document.getElementById('article').innerHTML;
if(article.indexOf(strAdBegin)!=-1){
str +=article.substr(0,article.indexOf(strAdBegin));
strTmp=article.substr(article.indexOf(strAdEnd)+strAdEnd.length, article.length);
}
else{
strTmp=article;
}
str +=strTmp
str += window.location.href
str += "</td></tr></table></center>";
str += "</body></html>";
document.write(str);
document.close();
}
</SCRIPT>
<META content="MSHTML 6.00.2900.2722" name=GENERATOR>
<base target="_blank">
</HEAD>
<BODY bgColor=#ffffff leftMargin=0 topMargin=1 marginwidth="0" marginheight="5">
<table width=760 border=0 align=center cellpadding=0 cellspacing=2 bgcolor=#E5E5E5>
<tr>
<td width=158><a href='http://www.acnow.net/'><img height=19 src="http://image.acnow.net/images/acnow_small.gif" width=158 border=0></a></td>
<td align=right><a href="http://www.acnow.net/" class="a01">首頁</a> | <a href="http://tech.acnow.net/" target="_blank" class="a01">學院</a> | <a href="http://games.acnow.net/" target="_blank" class="a01">游戲</a> | <a href="http://joke.acnow.net/" target="_blank" class="a01">笑話</a> | <a href="http://movie.acnow.net/" target="_blank" class="a01">影視</a> | <a href="http://music.acnow.net/" target="_blank" class="a01">音樂</a> | <a href="http://down.acnow.net/" target="_blank" class="a01">軟件</a> | <a href="http://flash.acnow.net/" target="_blank" class="a01">Flash</a> | <a href="http://bbs.acnow.net/" target="_blank" class="a01">論壇</a> | <a href="http://bbs.acnow.net/html/" target="_blank" class="a01">索引</a> | <a href="http://bt.acnow.net/" target="_blank" class="a01">bt下載</a> | <a href='http://sms.acnow.net/' target="_blank" class="a01"><font color=red>短信</font></a> </td>
</tr>
</table>
<TABLE width=760 border=0 align="center" cellPadding=0 cellSpacing=0 bgColor=#ffffff>
<tr bgcolor="#FF6600">
<td height="3" colspan="3"></td>
</tr>
<TR>
<TD height="76"> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TR>
<TD width="26%" height="79"><a href="http://tech.acnow.net/" target="_blank"><IMG src="http://image.acnow.net/pic/logo/LOGO.GIF" border="0" class=whitetil></a></TD>
<TD width="65%" align="center">
<IFRAME MARGINHEIGHT=0 MARGINWIDTH=0 FRAMEBORDER=0 WIDTH=468 HEIGHT=60 SCROLLING=NO SRC="http://iplus.allyes.com/main/adfshow?user=iplus|acnow|468x60&db=iplus&border=0&local=yes"><SCRIPT LANGUAGE="JavaScript1.1" SRC="http://iplus.allyes.com/main/adfshow?user=iplus|acnow|468x60&db=iplus&local=yes&js=on"></SCRIPT><NOSCRIPT><A HREF="http://iplus.allyes.com/main/adfclick?user=iplus|acnow|468x60&db=iplus"><IMG SRC="http://iplus.allyes.com/main/adfshow?user=iplus|acnow|468x60&db=iplus" WIDTH=468 HEIGHT=60 BORDER=0></a></NOSCRIPT></IFRAME>
</TD>
<TD width="9%" align=center><a style="cursor:pointer;" onclick="window.external.AddFavorite(document.location.href,document.title)" onmousemove="status='收藏本頁';" onmouseout="status='';">收藏本頁</a><br>
<a href="http://www.acnow.net/contact/" target="_blank">聯系我們</a><br>
<a href="http://www.acnow.net/cooperation/">廣告合作</a></TD>
</TR>
</TABLE></TD>
</TR>
</TABLE>
<table width="760" height="22" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#E7F3FF" style="border-collapse: collapse">
<tr bgcolor="#FF6600">
<td height="3" colspan="3"></td>
</tr>
<tr>
<td width="20%" align="center" height="20" nowrap><a href="http://tech.acnow.net/" >首頁</a></td>
<td width="20%" height="20"></td>
<td width="60%" align="right" height="20"><table border="0" width="100%;">
<tr>
<td><a href="/html/OS/" >操作系統</a></td>
<td><a href="/Html/NetWork/" >網絡技術</a></td>
<td><a href="/Html/SoftWare/" >軟件應用</a></td>
<td><a href="/Html/HardWare/" >硬件天地</a></td>
<td><a href="/Html/Program/" >編程開發</a></td>
<td><a href="/Html/Web/" >Web開發</a></td>
<td><a href="/Html/DataBase/" >數據庫</a></td>
<td><a href="/Html/webGuide/" >網站運營</a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#FF6600">
<td height="3" colspan="3"></td>
</tr>
<tr bgcolor="#0099CC">
<td height="3" colspan="3"><iframe scrolling="no" frameborder="0" width="760" height="90" src="http://js4.all4ad.net/dell/dell_760x90.asp?id=236"></iframe></td>
</tr>
</table><br />
<TABLE width=760 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width=150><A href="http://www.acnow.net/"><IMG height=19
alt=AcNow中文網 src="http://image.acnow.net/images/acnow_small.gif" width=158 border=0></A></TD>
<TD vAlign=bottom width=440><a target="_blank" href="http://tech.acnow.net/Index.shtml"><font color=red>首頁</font></a> >> <a target="_blank" href="http://tech.acnow.net/Html/DataBase/index.shtml" >數據庫</a> >> <a target="_blank" href="http://tech.acnow.net/Html/DataBase/Oracle/index.shtml" >Oracle</a> >> 正文</TD>
<TD vAlign=bottom align=right width=150></TD>
<TD width=10></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=760 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD height=8></TD>
</TR>
<TR>
<TD bgColor=#747474 height=1><IMG height=1 src="/Files/Img/c.gif"
width=1></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=760 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD vAlign=top align=middle width=600 bgColor=#edf0f5 rowSpan=2><BR>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -