如何创建合适的索引－主要是创建多列索引还是单列索引？

末蓝、 2022-05-29 08:17 176阅读 0赞

<table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; color:rgb(255,255,255)!important; table-layout:fixed; width:1284px"> 
 <tbody style="word-wrap:break-word"> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; padding-top:5px!important; padding-bottom:5px!important; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255); background:rgb(93,119,144)!important"> 
    <div style="word-wrap:break-word; text-align:center; padding-top:2px"> 
     <span style="word-wrap:break-word">查看:</span>&nbsp; 
     <span style="word-wrap:break-word">13665</span> 
     <span style="word-wrap:break-word; margin:0px 5px; color:rgb(204,204,204)">|</span> 
     <span style="word-wrap:break-word">回复:</span>&nbsp; 
     <span style="word-wrap:break-word">10</span> 
    </div> </td> 
   <td style="word-wrap:break-word; padding:0px 20px; vertical-align:top; background:rgb(93,119,144)!important"> 
    <div style="word-wrap:break-word; float:right; display:inline; margin-right:-60px"> 
     <a href="http://www.itpub.net/home.php?mod=spacecp&amp;ac=favorite&amp;type=thread&amp;id=298746" style="word-wrap:break-word; color:rgb(255,255,255)!important" rel="nofollow">收藏&nbsp;</a>|&nbsp; 
     <a href="http://www.itpub.net/forum.php?mod=viewthread&amp;action=printable&amp;tid=298746" title="打印" style="word-wrap:break-word; color:rgb(255,255,255)!important" rel="nofollow"><img src="http://www.itpub.net/template/itpub/image/print.png" alt="打印" style="word-wrap:break-word; border:none; vertical-align:middle"></a>&nbsp; 
     <a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=nextoldset&amp;tid=298746" title="上一主题" style="word-wrap:break-word; color:rgb(255,255,255)!important" rel="nofollow"><img src="http://www.itpub.net/template/itpub/image/thread-prev.png" alt="上一主题" style="word-wrap:break-word; border:none; vertical-align:middle"></a>&nbsp; 
     <a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=nextnewset&amp;tid=298746" title="下一主题" style="word-wrap:break-word; color:rgb(255,255,255)!important" rel="nofollow"><img src="http://www.itpub.net/template/itpub/image/thread-next.png" alt="下一主题" style="word-wrap:break-word; border:none; vertical-align:middle"></a> 
    </div> <h1 style="word-wrap:break-word; margin:0px; padding:0px; font-size:15px; display:inline; line-height:normal; font-family:&quot;Microsoft Yahei&quot;,Hei,Tahoma,SimHei,sans-serif"> <span style="word-wrap:break-word">如何创建合适的索引－主要是创建多列索引还是单列索引？</span>&nbsp;</h1> <span style="word-wrap:break-word; color:rgb(153,153,153)!important"><a href="http://www.itpub.net/thread-298746-1-1.html" style="word-wrap:break-word; color:rgb(255,255,255)!important" rel="nofollow">[复制链接]</a></span></td> 
  </tr> 
 </tbody> 
</table>

<table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; background-color:rgb(223,223,223); table-layout:fixed; width:1284px"> 
 <tbody style="word-wrap:break-word"> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> 
    <div style="word-wrap:break-word; vertical-align:top; width:160px; overflow:visible; border-width:0px; border-right-style:solid; border-right-color:rgb(255,255,255); background:transparent; height:auto; top:-151px"> 
     <a style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow"></a> 
     <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px 10px 15px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
      <div style="word-wrap:break-word"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=118392" style="word-wrap:break-word; color:rgb(51,51,51); font-weight:700" rel="nofollow">w_z_y</a> 
      </div> 
     </div> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; margin:10px 15px"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=118392" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow"><img src="http://passport.ixpub.net/images/noavatar_middle.gif" alt="" style="word-wrap:break-word; border:none; width:120px; height:auto; padding:5px 5px 8px"></a> 
      </div> 
     </div> 
     <dl style="word-wrap:break-word; margin:5px 10px 5px 20px; padding:0px; zoom:1">
       论坛徽章: 
      <dd style="word-wrap:break-word; margin:0px; padding:0px; float:left; overflow:hidden; height:1.6em; line-height:1.6em; width:70px">
        0 
      </dd> 
     </dl> 
     <div style="word-wrap:break-word; padding:3px; margin-left:5px; margin-right:5px"> 
     </div> 
    </div> </td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> 
    <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
     <div style="word-wrap:break-word; float:right; margin-left:5px"> 电梯直达  
      <a title="跳转到指定楼层" style="word-wrap:break-word; color:rgb(51,51,51); float:left" rel="nofollow"><img src="http://www.itpub.net/template/itpub/image/fj_btn.png" alt="跳转到指定楼层" style="word-wrap:break-word; border:none; vertical-align:middle"></a> 
     </div> 
     <span style="word-wrap:break-word"><a href="http://www.itpub.net/thread-298746-1-1.html" style="word-wrap:break-word; color:rgb(51,51,51); float:right; margin-top:-6px; padding:4px 6px; font-weight:400" rel="nofollow"><span style="word-wrap:break-word">1</span><sup style="word-wrap:break-word">#</sup></a></span> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; float:right; margin:-5px 10px 0px 0px"> 
      </div> 
      <div style="word-wrap:break-word"> 
       <img src="http://www.itpub.net/static/image/common/online_member.gif" alt="" style="word-wrap:break-word; vertical-align:middle; width:16px">&nbsp; 
       <span style="word-wrap:break-word">发表于 2004-12-8 15:21</span>&nbsp; 
       <span style="word-wrap:break-word; margin:0px 5px; color:rgb(204,204,204)">|</span>&nbsp; 
       <a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=298746&amp;page=1&amp;authorid=118392" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow">只看该作者</a>&nbsp; 
       <span style="word-wrap:break-word; display:inline-block"><img src="http://www.itpub.net/template/itpub/image/arw_r.gif" alt="回帖奖励" style="word-wrap:break-word; vertical-align:middle"></span> 
      </div> 
     </div> 
    </div> 
    <div style="word-wrap:break-word; padding-bottom:1em"> 
     <div style="word-wrap:break-word; clear:left; margin-right:0px"> 
      <div style="word-wrap:break-word; min-height:100px"> 
       <table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; table-layout:fixed; width:1083px"> 
        <tbody style="word-wrap:break-word"> 
         <tr style="word-wrap:break-word"> 
          <td style="word-wrap:break-word; font-size:14px"> <span style="word-wrap:break-word; font-weight:700"><span style="color:#FF0000; word-wrap:break-word"></span></span>如我有一个表<br style="word-wrap:break-word"> UserInfo<br style="word-wrap:break-word"> { <br style="word-wrap:break-word"> &nbsp; &nbsp;id number(10,0) not null,<br style="word-wrap:break-word"> &nbsp; &nbsp;username varchar(100) not null,<br style="word-wrap:break-word"> &nbsp; &nbsp;realname varchar(100) not null,<br style="word-wrap:break-word"> &nbsp; &nbsp;<a href="http://www.itpub.net/tree/index_339/" style="word-wrap:break-word; color:rgb(51,102,153); border-bottom:1px solid blue" rel="nofollow">bi</a>rthday date not null<br style="word-wrap:break-word"> }<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 其中id列是PK，username 是唯一键(unique)<br style="word-wrap:break-word"> 以上四列经常被当作条件放到where 字句里面。<br style="word-wrap:break-word"> 我是分别在每一列上创建一个索引，还创建一个索引包含一列呢？<br style="word-wrap:break-word"> 请多指教！！<br style="word-wrap:break-word"> 如：<br style="word-wrap:break-word"> 1）select * from userInfo where id = 10;<br style="word-wrap:break-word"> select * from userInfo where username = '1111';<br style="word-wrap:break-word"> select * from userInfo where name = '1111';<br style="word-wrap:break-word"> select * from userInfo where birthday= to_date('2003-10-10','yyyy-mm-dd');<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 这个肯定创建单列索引了<br style="word-wrap:break-word"> 2）select * from userinfo where&nbsp;&nbsp;name = '2222' and birthday= to_date('2003-10-10','yyyy-mm-dd');<br style="word-wrap:break-word"> 如何创建索引？？<br style="word-wrap:break-word"> 3）select * from userinfo where&nbsp;&nbsp;id = 1111 and name = '2222' and birthday= to_date('2003-10-10','yyyy-mm-dd');</td> 
         </tr> 
        </tbody> 
       </table> 
      </div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word"></div> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> 
    <div style="word-wrap:break-word; margin-top:20px!important; margin-bottom:20px!important"> 
     <div style="word-wrap:break-word; height:32px; border-bottom:1px solid rgb(143,156,168); position:relative"> 
      <ul style="word-wrap:break-word; margin:0px; padding:0px; position:absolute; bottom:-1px"> 
       <li style="word-wrap:break-word; margin:0px 5px 0px 0px; padding:0px; list-style:none; width:140px; float:left; height:32px; line-height:32px; text-align:center"> <a style="word-wrap:break-word; color:rgb(79,79,103); display:block; width:140px; height:32px; font-size:13px; font-weight:bold" rel="nofollow">本版精华</a></li> 
      </ul> 
     </div> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word"> 
       <ul style="word-wrap:break-word; margin:0px auto; padding:17px 0px 0px; width:1083px; overflow:hidden"> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-2053618-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">技术人生系列 · 我和数据中心的故事（第六期）-Oracle内存过度消耗风险提醒</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-1846862-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">Oracle SQL命令通解三步曲</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-2051086-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">技术人生系列 · 我和数据中心的故事（第一期）——小机上运行Oracle数据库需要注意的</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-1814173-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">《Oracle Golden Gate图文并茂快速掌握》（附下载）</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-2063121-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">Oracle 运维最佳实践</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-2089835-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">Oracle中的锁和10704对高级队列锁的跟踪实验</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-1307822-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">无私奉献 企业级DBA--学习手册(中文版)体系结构,性能优化</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-2085022-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">数据库笔试面试题库（Oracle、MySQL、MS SQL Server等）</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-1801129-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">自动化运维趋势越来越猛，DBA将何去何从。</a></li> 
        <li style="word-wrap:break-word; margin:0px 0px 0px 32.4844px; padding:0px 0px 0px 11px; list-style:none; height:22px; line-height:22px; overflow:hidden; width:487.344px; float:left; display:inline"> <a href="http://www.itpub.net/thread-1815817-1-1.html" style="word-wrap:break-word; color:rgb(0,89,130)" rel="nofollow">Oracle 12C 集群安装（4节点）详解</a></li> 
       </ul> 
       <div style="word-wrap:break-word"></div> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"></tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px; overflow:visible"> 
    <div style="word-wrap:break-word; border-top:1px dashed rgb(205,205,205)"> 
     <div style="word-wrap:break-word; zoom:1; line-height:36px"> 
      <p style="word-wrap:break-word; margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; float:right"> <a style="word-wrap:break-word; color:rgb(51,51,51); padding-right:16px; white-space:nowrap; margin-right:6px" rel="nofollow">使用道具</a>&nbsp;<a style="word-wrap:break-word; color:rgb(51,51,51); margin-right:6px" rel="nofollow">举报</a></p> 
      <span style="word-wrap:break-word; float:right"><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=2&amp;tid=298746&amp;reppost=2017112&amp;extra=page%3D1&amp;page=1" style="word-wrap:break-word; color:rgb(51,51,51); padding:5px 10px 5px 0px" rel="nofollow">回复</a></span> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255); background:rgb(255,255,255); padding:0px; height:4px"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px; background:rgb(255,255,255); overflow:hidden"> &nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; background-color:rgb(241,241,241); table-layout:fixed; width:1284px"> 
 <tbody style="word-wrap:break-word"> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> 
    <div style="word-wrap:break-word; vertical-align:top; width:160px; overflow:visible; border-width:0px; border-right-style:solid; border-right-color:rgb(255,255,255); background:transparent; height:auto"> 
     <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px 10px 15px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
      <div style="word-wrap:break-word"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=48934" style="word-wrap:break-word; color:rgb(51,51,51); font-weight:700" rel="nofollow">grassbell</a> 
      </div> 
     </div> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; margin:10px 15px"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=48934" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow"><img src="http://passport.ixpub.net/data/avatar/000/04/89/34_avatar_middle.jpg" alt="" style="word-wrap:break-word; border:none; width:120px; height:auto; padding:5px 5px 8px"></a> 
      </div> 
     </div> 
     <dl style="word-wrap:break-word; margin:5px 10px 5px 20px; padding:0px; zoom:1">
       招聘 :&nbsp; 
      <a href="http://www.itpub.net/thread-1865350-1-1.html" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow">数据库管理员</a> 
     </dl> 
     <dl style="word-wrap:break-word; margin:5px 10px 5px 20px; padding:0px; zoom:1">
       论坛徽章: 
      <dd style="word-wrap:break-word; margin:0px; padding:0px; float:left; overflow:hidden; height:1.6em; line-height:1.6em; width:70px">
        21 
      </dd> 
     </dl> 
     <div style="word-wrap:break-word; padding:3px; margin-left:5px; margin-right:5px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_14_small.gif" width="24px" alt="授权会员日期:2005-10-30 17:05:33" title="授权会员日期:2005-10-30 17:05:33" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2012fuzhang-small.gif" width="24px" alt="2012新春纪念徽章日期:2012-02-13 15:11:36" title="2012新春纪念徽章日期:2012-02-13 15:11:36" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2012fuzhang-small.gif" width="24px" alt="2012新春纪念徽章日期:2012-02-13 15:11:36" title="2012新春纪念徽章日期:2012-02-13 15:11:36" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2012fuzhang-small.gif" width="24px" alt="2012新春纪念徽章日期:2012-02-13 15:11:36" title="2012新春纪念徽章日期:2012-02-13 15:11:36" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2012fuzhang-small.gif" width="24px" alt="2012新春纪念徽章日期:2012-02-13 15:11:36" title="2012新春纪念徽章日期:2012-02-13 15:11:36" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/mache-small.gif" width="24px" alt="马上有车日期:2014-02-19 11:55:14" title="马上有车日期:2014-02-19 11:55:14" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/mafang-small.gif" width="24px" alt="马上有房日期:2014-02-19 11:55:14" title="马上有房日期:2014-02-19 11:55:14" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/maqian-small.gif" width="24px" alt="马上有钱日期:2014-02-19 11:55:14" title="马上有钱日期:2014-02-19 11:55:14" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/mayi-small.gif" width="24px" alt="马上有对象日期:2014-02-19 11:55:14" title="马上有对象日期:2014-02-19 11:55:14" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2012fuzhang-small.gif" width="24px" alt="2012新春纪念徽章日期:2012-02-13 15:11:36" title="2012新春纪念徽章日期:2012-02-13 15:11:36" style="word-wrap:break-word; margin:2px"> 
     </div> 
    </div> </td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> 
    <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
     <span style="word-wrap:break-word"><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=298746&amp;pid=2061473" style="word-wrap:break-word; color:rgb(51,51,51); float:right; margin-top:-6px; padding:4px 6px; font-weight:400" rel="nofollow"><span style="word-wrap:break-word">4</span><sup style="word-wrap:break-word">#</sup></a></span> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; float:right; margin:-5px 10px 0px 0px"> 
      </div> 
      <div style="word-wrap:break-word"> 
       <img src="http://www.itpub.net/static/image/common/online_moderator.gif" alt="" style="word-wrap:break-word; vertical-align:middle; width:16px">&nbsp; 
       <span style="word-wrap:break-word">发表于 2004-12-26 17:27</span>&nbsp; 
       <span style="word-wrap:break-word; margin:0px 5px; color:rgb(204,204,204)">|</span>&nbsp; 
       <a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=298746&amp;page=1&amp;authorid=48934" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow">只看该作者</a> 
      </div> 
     </div> 
    </div> 
    <div style="word-wrap:break-word; padding-bottom:1em"> 
     <div style="word-wrap:break-word; clear:left; margin-right:0px"> 
      <div style="word-wrap:break-word; min-height:100px"> 
       <table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; table-layout:fixed; width:1083px"> 
        <tbody style="word-wrap:break-word"> 
         <tr style="word-wrap:break-word"> 
          <td style="word-wrap:break-word; font-size:14px"> 
           <div style="word-wrap:break-word; overflow:hidden; margin:10px 0px; padding:10px 10px 5px 65px; color:rgb(102,102,102); zoom:1"> 
            <blockquote style="word-wrap:break-word; display:inline-block; margin:0px; padding:0px 65px 5px 0px; line-height:1.6; zoom:1"> 
             <span style="word-wrap:break-word">最初由 oracle-plus 发布</span> 
             <br style="word-wrap:break-word"> [B] 
             <br style="word-wrap:break-word"> 有一點也注意的是：如果索引是建立在多个列上, 只有在它的第一个列(leading column)被where子句引用时,优化器才会选择使用该索引。 
             <br style="word-wrap:break-word"> 所以，你要根據你的查詢需求來決定是否使用Composite Indexes [/B] 
            </blockquote> 
           </div> <br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 这个是8i的限制，9i不是这样了</td> 
         </tr> 
        </tbody> 
       </table> 
      </div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word; margin:0px auto; padding:10px"> 
       <div style="word-wrap:break-word; margin:10px auto; text-align:center"> 
       </div> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> &nbsp;</td> 
  </tr> 
  <tr style="word-wrap:break-word"></tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px; overflow:visible"> 
    <div style="word-wrap:break-word; border-top:1px dashed rgb(205,205,205)"> 
     <div style="word-wrap:break-word; zoom:1; line-height:36px"> 
      <p style="word-wrap:break-word; margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; float:right"> <a style="word-wrap:break-word; color:rgb(51,51,51); padding-right:16px; white-space:nowrap; margin-right:6px" rel="nofollow">使用道具</a>&nbsp;<a style="word-wrap:break-word; color:rgb(51,51,51); margin-right:6px" rel="nofollow">举报</a></p> 
      <span style="word-wrap:break-word; float:right"><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=2&amp;tid=298746&amp;repquote=2061473&amp;extra=page%3D1&amp;page=1" style="word-wrap:break-word; color:rgb(51,51,51); padding:5px 10px 5px 0px" rel="nofollow">回复</a></span> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255); background:rgb(255,255,255); padding:0px; height:4px"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px; background:rgb(255,255,255); overflow:hidden"> &nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; background-color:rgb(241,241,241); table-layout:fixed; width:1284px"> 
 <tbody style="word-wrap:break-word"> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> 
    <div style="word-wrap:break-word; vertical-align:top; width:160px; overflow:visible; border-width:0px; border-right-style:solid; border-right-color:rgb(255,255,255); background:transparent; height:auto"> 
     <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px 10px 15px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
      <div style="word-wrap:break-word"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=16648" style="word-wrap:break-word; color:rgb(51,51,51); font-weight:700" rel="nofollow">xzh2000</a> 
      </div> 
     </div> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; margin:10px 15px"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=16648" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow"><img src="http://passport.ixpub.net/data/avatar/000/01/66/48_avatar_middle.jpg" alt="" style="word-wrap:break-word; border:none; width:120px; height:auto; padding:5px 5px 8px"></a> 
      </div> 
     </div> 
     <dl style="word-wrap:break-word; margin:5px 10px 5px 20px; padding:0px; zoom:1">
       招聘 :&nbsp; 
      <a href="http://www.itpub.net/thread-1864830-1-1.html" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow">数据库管理员</a> 
     </dl> 
     <dl style="word-wrap:break-word; margin:5px 10px 5px 20px; padding:0px; zoom:1">
       论坛徽章: 
      <dd style="word-wrap:break-word; margin:0px; padding:0px; float:left; overflow:hidden; height:1.6em; line-height:1.6em; width:70px">
        66 
      </dd> 
     </dl> 
     <div style="word-wrap:break-word; padding:3px; margin-left:5px; margin-right:5px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_1_small.gif" width="24px" alt="ITPUB元老日期:2005-07-16 18:49:11" title="ITPUB元老日期:2005-07-16 18:49:11" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_14_small.gif" width="24px" alt="授权会员日期:2005-10-30 17:05:33" title="授权会员日期:2005-10-30 17:05:33" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/home_small.gif" width="24px" alt="ITPUB新首页上线纪念徽章日期:2007-10-20 08:38:44" title="ITPUB新首页上线纪念徽章日期:2007-10-20 08:38:44" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_15_small.gif" width="24px" alt="现任管理团队成员日期:2011-05-07 01:45:08" title="现任管理团队成员日期:2011-05-07 01:45:08" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/grade3-small.gif" width="24px" alt="版主3段日期:2012-05-15 15:24:11" title="版主3段日期:2012-05-15 15:24:11" style="word-wrap:break-word; margin:2px"> 
     </div> 
    </div> </td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> 
    <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
     <span style="word-wrap:break-word"><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=298746&amp;pid=2061551" style="word-wrap:break-word; color:rgb(51,51,51); float:right; margin-top:-6px; padding:4px 6px; font-weight:400" rel="nofollow"><span style="word-wrap:break-word">6</span><sup style="word-wrap:break-word">#</sup></a></span> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; float:right; margin:-5px 10px 0px 0px"> 
      </div> 
      <div style="word-wrap:break-word"> 
       <img src="http://www.itpub.net/static/image/common/online_moderator.gif" alt="" style="word-wrap:break-word; vertical-align:middle; width:16px">&nbsp; 
       <span style="word-wrap:break-word">发表于 2004-12-26 18:05</span>&nbsp; 
       <span style="word-wrap:break-word; margin:0px 5px; color:rgb(204,204,204)">|</span>&nbsp; 
       <a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=298746&amp;page=1&amp;authorid=16648" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow">只看该作者</a> 
      </div> 
     </div> 
    </div> 
    <div style="word-wrap:break-word; padding-bottom:1em"> 
     <div style="word-wrap:break-word; clear:left; margin-right:0px"> 
      <div style="word-wrap:break-word; min-height:100px"> 
       <table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; table-layout:fixed; width:1083px"> 
        <tbody style="word-wrap:break-word"> 
         <tr style="word-wrap:break-word"> 
          <td style="word-wrap:break-word; font-size:14px"> 三个索引足了<br style="word-wrap:break-word"> 1 id上的主键<br style="word-wrap:break-word"> 2 username上的unique index<br style="word-wrap:break-word"> 3 name+birthday的组合索引</td> 
         </tr> 
        </tbody> 
       </table> 
      </div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word; margin:0px auto; padding:10px"> 
       <div style="word-wrap:break-word; margin:10px auto; text-align:center"> 
       </div> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> &nbsp;</td> 
  </tr> 
  <tr style="word-wrap:break-word"></tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px; overflow:visible"> 
    <div style="word-wrap:break-word; border-top:1px dashed rgb(205,205,205)"> 
     <div style="word-wrap:break-word; zoom:1; line-height:36px"> 
      <p style="word-wrap:break-word; margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; float:right"> <a style="word-wrap:break-word; color:rgb(51,51,51); padding-right:16px; white-space:nowrap; margin-right:6px" rel="nofollow">使用道具</a>&nbsp;<a style="word-wrap:break-word; color:rgb(51,51,51); margin-right:6px" rel="nofollow">举报</a></p> 
      <span style="word-wrap:break-word; float:right"><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=2&amp;tid=298746&amp;repquote=2061551&amp;extra=page%3D1&amp;page=1" style="word-wrap:break-word; color:rgb(51,51,51); padding:5px 10px 5px 0px" rel="nofollow">回复</a></span> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255); background:rgb(255,255,255); padding:0px; height:4px"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px; background:rgb(255,255,255); overflow:hidden"> &nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; background-color:rgb(223,223,223); table-layout:fixed; width:1284px"> 
 <tbody style="word-wrap:break-word"> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> 
    <div style="word-wrap:break-word; vertical-align:top; width:160px; overflow:visible; border-width:0px; border-right-style:solid; border-right-color:rgb(255,255,255); background:transparent; height:auto; top:-262px"> 
     <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px 10px 15px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
      <div style="word-wrap:break-word"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=7659204" style="word-wrap:break-word; color:rgb(51,51,51); font-weight:700" rel="nofollow">hanjs</a> 
      </div> 
     </div> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; margin:10px 15px"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=7659204" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow"><img src="http://passport.ixpub.net/data/avatar/007/65/92/04_avatar_middle.jpg" alt="" style="word-wrap:break-word; border:none; width:120px; height:auto; padding:5px 5px 8px"></a> 
      </div> 
     </div> 
     <dl style="word-wrap:break-word; margin:5px 10px 5px 20px; padding:0px; zoom:1">
       论坛徽章: 
      <dd style="word-wrap:break-word; margin:0px; padding:0px; float:left; overflow:hidden; height:1.6em; line-height:1.6em; width:70px">
        24 
      </dd> 
     </dl> 
     <div style="word-wrap:break-word; padding:3px; margin-left:5px; margin-right:5px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/050.gif" width="24px" alt="生肖徽章:狗日期:2006-09-07 10:14:43" title="生肖徽章:狗日期:2006-09-07 10:14:43" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif" width="24px" alt="数据库板块每日发贴之星日期:2008-07-26 01:02:20" title="数据库板块每日发贴之星日期:2008-07-26 01:02:20" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-04small.gif" width="24px" alt="生肖徽章2007版:兔日期:2008-10-13 11:10:11" title="生肖徽章2007版:兔日期:2008-10-13 11:10:11" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/y26.gif" width="24px" alt="奥运会纪念徽章:铁人三项日期:2008-10-24 13:27:21" title="奥运会纪念徽章:铁人三项日期:2008-10-24 13:27:21" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_11_small.gif" width="24px" alt="开发板块每日发贴之星日期:2008-12-27 01:01:09" title="开发板块每日发贴之星日期:2008-12-27 01:01:09" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-07small.gif" width="24px" alt="生肖徽章2007版:马日期:2009-11-18 10:45:03" title="生肖徽章2007版:马日期:2009-11-18 10:45:03" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2010_hu_small.gif" width="24px" alt="2010新春纪念徽章日期:2010-03-01 11:21:02" title="2010新春纪念徽章日期:2010-03-01 11:21:02" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/zc2010small.gif" width="24px" alt="ITPUB9周年纪念徽章日期:2010-10-08 09:28:51" title="ITPUB9周年纪念徽章日期:2010-10-08 09:28:51" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_8_small.gif" width="24px" alt="ERP板块每日发贴之星日期:2011-05-18 01:01:01" title="ERP板块每日发贴之星日期:2011-05-18 01:01:01" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2012fuzhang-small.gif" width="24px" alt="2012新春纪念徽章日期:2012-01-04 11:51:22" title="2012新春纪念徽章日期:2012-01-04 11:51:22" style="word-wrap:break-word; margin:2px"> 
     </div> 
    </div> </td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> 
    <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
     <span style="word-wrap:break-word"><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=298746&amp;pid=8984592" style="word-wrap:break-word; color:rgb(51,51,51); float:right; margin-top:-6px; padding:4px 6px; font-weight:400" rel="nofollow"><span style="word-wrap:break-word">7</span><sup style="word-wrap:break-word">#</sup></a></span> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; float:right; margin:-5px 10px 0px 0px"> 
      </div> 
      <div style="word-wrap:break-word"> 
       <img src="http://www.itpub.net/static/image/common/online_member.gif" alt="" style="word-wrap:break-word; vertical-align:middle; width:16px">&nbsp; 
       <span style="word-wrap:break-word">发表于 2007-11-15 18:15</span>&nbsp; 
       <span style="word-wrap:break-word; margin:0px 5px; color:rgb(204,204,204)">|</span>&nbsp; 
       <a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=298746&amp;page=1&amp;authorid=7659204" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow">只看该作者</a> 
      </div> 
     </div> 
    </div> 
    <div style="word-wrap:break-word; padding-bottom:1em"> 
     <div style="word-wrap:break-word; clear:left; margin-right:0px"> 
      <div style="word-wrap:break-word; min-height:100px"> 
       <table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; table-layout:fixed; width:1083px"> 
        <tbody style="word-wrap:break-word"> 
         <tr style="word-wrap:break-word"> 
          <td style="word-wrap:break-word; font-size:14px"> 
           <div style="word-wrap:break-word; overflow:hidden; margin:10px 0px; padding:10px 10px 5px 65px; color:rgb(102,102,102); zoom:1"> 
            <blockquote style="word-wrap:break-word; display:inline-block; margin:0px; padding:0px 65px 5px 0px; line-height:1.6; zoom:1"> 
             <span style="word-wrap:break-word">最初由 grassbell 发布</span> 
             <br style="word-wrap:break-word"> [B] 
             <br style="word-wrap:break-word"> 
             <br style="word-wrap:break-word"> 这个是8i的限制，9i不是这样了 [/B] 
            </blockquote> 
           </div> <br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 这个要看sql怎么写的。<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> SQL&gt; desc user_info<br style="word-wrap:break-word"> 名称&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;是否为空? 类型<br style="word-wrap:break-word"> ----------------------------------------- -------- ----------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> ID&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; NUMBER<br style="word-wrap:break-word"> CODE&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;VARCHAR2(10)<br style="word-wrap:break-word"> NAME&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;VARCHAR2(20)<br style="word-wrap:break-word"> FDATE&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; DATE<br style="word-wrap:break-word"> REMARK&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;VARCHAR2(50)<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 在name,fdate上建立复合索引。<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> select name,fdate from user_info where fdate=trunc(sysdate)<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 这样可以利用到索引，如果查询中还有别的列，那么就不行了！<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 一般我们认为like '%xx%'是不会走索引的，可是如果只查询了索引列或count等，还是可以利用索引的！</td> 
         </tr> 
        </tbody> 
       </table> 
      </div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word; margin:0px auto; padding:10px"> 
       <div style="word-wrap:break-word; margin:10px auto; text-align:center"> 
       </div> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> &nbsp;</td> 
  </tr> 
  <tr style="word-wrap:break-word"></tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px; overflow:visible"> 
    <div style="word-wrap:break-word; border-top:1px dashed rgb(205,205,205)"> 
     <div style="word-wrap:break-word; zoom:1; line-height:36px"> 
      <p style="word-wrap:break-word; margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; float:right"> <a style="word-wrap:break-word; color:rgb(51,51,51); padding-right:16px; white-space:nowrap; margin-right:6px" rel="nofollow">使用道具</a>&nbsp;<a style="word-wrap:break-word; color:rgb(51,51,51); margin-right:6px" rel="nofollow">举报</a></p> 
      <span style="word-wrap:break-word; float:right"><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=2&amp;tid=298746&amp;repquote=8984592&amp;extra=page%3D1&amp;page=1" style="word-wrap:break-word; color:rgb(51,51,51); padding:5px 10px 5px 0px" rel="nofollow">回复</a></span> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255); background:rgb(255,255,255); padding:0px; height:4px"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px; background:rgb(255,255,255); overflow:hidden"> &nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; background-color:rgb(223,223,223); table-layout:fixed; width:1284px"> 
 <tbody style="word-wrap:break-word"> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> 
    <div style="word-wrap:break-word; vertical-align:top; width:160px; overflow:visible; border-width:0px; border-right-style:solid; border-right-color:rgb(255,255,255); background:transparent; height:auto; top:-192px"> 
     <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px 10px 15px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
      <div style="word-wrap:break-word"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=9340716" style="word-wrap:break-word; color:rgb(51,51,51); font-weight:700" rel="nofollow">seamanczg1984</a> 
      </div> 
     </div> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; margin:10px 15px"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=9340716" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow"><img src="http://passport.ixpub.net/images/noavatar_middle.gif" alt="" style="word-wrap:break-word; border:none; width:120px; height:auto; padding:5px 5px 8px"></a> 
      </div> 
     </div> 
     <dl style="word-wrap:break-word; margin:5px 10px 5px 20px; padding:0px; zoom:1">
       论坛徽章: 
      <dd style="word-wrap:break-word; margin:0px; padding:0px; float:left; overflow:hidden; height:1.6em; line-height:1.6em; width:70px">
        8 
      </dd> 
     </dl> 
     <div style="word-wrap:break-word; padding:3px; margin-left:5px; margin-right:5px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2007-2small.gif" width="24px" alt="会员2007贡献徽章日期:2007-09-26 18:42:10" title="会员2007贡献徽章日期:2007-09-26 18:42:10" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/home_small.gif" width="24px" alt="ITPUB新首页上线纪念徽章日期:2007-10-20 08:38:44" title="ITPUB新首页上线纪念徽章日期:2007-10-20 08:38:44" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-10small.gif" width="24px" alt="生肖徽章2007版:鸡日期:2008-01-02 17:35:53" title="生肖徽章2007版:鸡日期:2008-01-02 17:35:53" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-09small.gif" width="24px" alt="生肖徽章2007版:猴日期:2008-01-02 17:35:53" title="生肖徽章2007版:猴日期:2008-01-02 17:35:53" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-01small.gif" width="24px" alt="生肖徽章2007版:鼠日期:2008-01-02 17:35:53" title="生肖徽章2007版:鼠日期:2008-01-02 17:35:53" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2008newyear_small.gif" width="24px" alt="2008新春纪念徽章日期:2008-02-13 12:43:03" title="2008新春纪念徽章日期:2008-02-13 12:43:03" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2009_niu_small.gif" width="24px" alt="2009新春纪念徽章日期:2009-01-04 14:52:28" title="2009新春纪念徽章日期:2009-01-04 14:52:28" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/10years_small.gif" width="24px" alt="ITPUB十周年纪念徽章日期:2011-11-01 16:23:26" title="ITPUB十周年纪念徽章日期:2011-11-01 16:23:26" style="word-wrap:break-word; margin:2px"> 
     </div> 
    </div> </td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> 
    <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
     <span style="word-wrap:break-word"><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=298746&amp;pid=8985796" style="word-wrap:break-word; color:rgb(51,51,51); float:right; margin-top:-6px; padding:4px 6px; font-weight:400" rel="nofollow"><span style="word-wrap:break-word">9</span><sup style="word-wrap:break-word">#</sup></a></span> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; float:right; margin:-5px 10px 0px 0px"> 
      </div> 
      <div style="word-wrap:break-word"> 
       <img src="http://www.itpub.net/static/image/common/online_member.gif" alt="" style="word-wrap:break-word; vertical-align:middle; width:16px">&nbsp; 
       <span style="word-wrap:break-word">发表于 2007-11-15 21:52</span>&nbsp; 
       <span style="word-wrap:break-word; margin:0px 5px; color:rgb(204,204,204)">|</span>&nbsp; 
       <a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=298746&amp;page=1&amp;authorid=9340716" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow">只看该作者</a> 
      </div> 
     </div> 
    </div> 
    <div style="word-wrap:break-word; padding-bottom:1em"> 
     <div style="word-wrap:break-word; clear:left; margin-right:0px"> 
      <div style="word-wrap:break-word; min-height:100px"> 
       <table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; table-layout:fixed; width:1083px"> 
        <tbody style="word-wrap:break-word"> 
         <tr style="word-wrap:break-word"> 
          <td style="word-wrap:break-word; font-size:14px"> 
           <div style="word-wrap:break-word; overflow:hidden; margin:10px 0px; padding:10px 10px 5px 65px; color:rgb(102,102,102); zoom:1"> 
            <blockquote style="word-wrap:break-word; display:inline-block; margin:0px; padding:0px 65px 5px 0px; line-height:1.6; zoom:1"> 
             <span style="word-wrap:break-word">最初由 hanjs 发布</span> 
             <br style="word-wrap:break-word"> [B] 
             <br style="word-wrap:break-word"> 
             <br style="word-wrap:break-word"> 这个要看sql怎么写的。 
             <br style="word-wrap:break-word"> 
             <br style="word-wrap:break-word"> SQL&gt; desc user_info 
             <br style="word-wrap:break-word"> 名称&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;是否为空? 类型 
             <br style="word-wrap:break-word"> ----------------------------------------- -------- ---------------------------- 
             <br style="word-wrap:break-word"> 
             <br style="word-wrap:break-word"> ID&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; NUMBER 
             <br style="word-wrap:break-word"> CODE&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;VARCHAR2(10) 
             <br style="word-wrap:break-word"> NAME&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;VARCHAR2(20) 
             <br style="word-wrap:break-word"> FDATE&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; DATE 
             <br style="word-wrap:break-word"> REMARK&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;VARCHAR2(50) 
             <br style="word-wrap:break-word"> 
             <br style="word-wrap:break-word"> 在name,fdate上建立复合索引。 
             <br style="word-wrap:break-word"> 
             <br style="word-wrap:break-word"> select name,fdate from user_info where fdate=trunc(sysdate) 
             <br style="word-wrap:break-word"> 
             <br style="word-wrap:break-word"> 这样可以利用到索引，如果查询中还有别的列，那么就不行了！ 
             <br style="word-wrap:break-word"> 
             <br style="word-wrap:break-word"> 一般我们认为like '%xx%'是不会走索引的，可是如果只查询了索引列或count等，还是可以利用索引的！ [/B] 
            </blockquote> 
           </div> <br style="word-wrap:break-word"> <br style="word-wrap:break-word"> SQL&gt; create table test1(id int,code varchar2(20),zode varchar2(10));<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> Table created.<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> SQL&gt; begin<br style="word-wrap:break-word"> &nbsp;&nbsp;2&nbsp; &nbsp;&nbsp;&nbsp;for i in 1..1000 loog<br style="word-wrap:break-word"> &nbsp;&nbsp;3&nbsp;&nbsp;/<br style="word-wrap:break-word"> &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;for i in 1..1000 loog<br style="word-wrap:break-word"> &nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; *<br style="word-wrap:break-word"> ERROR at line 2:<br style="word-wrap:break-word"> ORA-06550: line 2, column 19:<br style="word-wrap:break-word"> PLS-00103: Encountered the symbol "LOOG" when expecting one of the following:<br style="word-wrap:break-word"> * &amp; - + / at loop mod remainder rem &lt;an exponent (**)&gt; ||<br style="word-wrap:break-word"> multiset<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> <br style="word-wrap:break-word"> SQL&gt; begin<br style="word-wrap:break-word"> &nbsp;&nbsp;2&nbsp; &nbsp;&nbsp;&nbsp;for i in 1..1000 loop<br style="word-wrap:break-word"> &nbsp;&nbsp;3&nbsp; &nbsp;&nbsp;&nbsp;insert into test1 values(i,'xxx'||i,'zode'||i);<br style="word-wrap:break-word"> &nbsp;&nbsp;4&nbsp; &nbsp;&nbsp;&nbsp;end loop;<br style="word-wrap:break-word"> &nbsp;&nbsp;5&nbsp;&nbsp;commit;<br style="word-wrap:break-word"> &nbsp;&nbsp;6&nbsp;&nbsp;end;<br style="word-wrap:break-word"> &nbsp;&nbsp;7&nbsp;&nbsp;/<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> PL/SQL procedure successfully completed.<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> SQL&gt; create index ind_id_code on test1(id,code);<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> Index created.<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> SQL&gt; set autotrace on<br style="word-wrap:break-word"> SQL&gt; set autotrace trace<br style="word-wrap:break-word"> SQL&gt; set autotrace<br style="word-wrap:break-word"> Usage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]<br style="word-wrap:break-word"> SQL&gt; set autotrace trace exp<br style="word-wrap:break-word"> SQL&gt; select id,code from test1 where code='xxx10';<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> Execution Plan<br style="word-wrap:break-word"> ----------------------------------------------------------<br style="word-wrap:break-word"> Plan hash value: 3343096337<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> --------------------------------------------------------------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> ----<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> | Id&nbsp;&nbsp;| Operation&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;| Name&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;| Rows&nbsp;&nbsp;| Bytes | Cost (%CPU)| Time<br style="word-wrap:break-word"> &nbsp; &nbsp;|<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> --------------------------------------------------------------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> ----<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> |&nbsp; &nbsp;0 | SELECT STATEMENT&nbsp; &nbsp;&nbsp;&nbsp;|&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; |&nbsp; &nbsp;&nbsp;&nbsp;1 |&nbsp; &nbsp; 25 |&nbsp; &nbsp;&nbsp;&nbsp;3&nbsp; &nbsp;(0)| 00:00:<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 01 |<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> |*&nbsp;&nbsp;1 |&nbsp;&nbsp;INDEX FAST FULL SCAN| IND_ID_CODE |&nbsp; &nbsp;&nbsp;&nbsp;1 |&nbsp; &nbsp; 25 |&nbsp; &nbsp;&nbsp;&nbsp;3&nbsp; &nbsp;(0)| 00:00:<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 01 |<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> --------------------------------------------------------------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> ----<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> <br style="word-wrap:break-word"> Predicate Information (identified by operation id):<br style="word-wrap:break-word"> ---------------------------------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> &nbsp; &nbsp;1 - filter("CODE"='xxx10')<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> Note<br style="word-wrap:break-word"> -----<br style="word-wrap:break-word"> &nbsp; &nbsp;- dynamic sampling used for this statement<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> SQL&gt;<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 是index fast full scan啊，</td> 
         </tr> 
        </tbody> 
       </table> 
      </div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word"></div> 
      <div style="word-wrap:break-word; margin:0px auto; padding:10px"> 
       <div style="word-wrap:break-word; margin:10px auto; text-align:center"> 
       </div> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> &nbsp;</td> 
  </tr> 
  <tr style="word-wrap:break-word"></tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px; overflow:visible"> 
    <div style="word-wrap:break-word; border-top:1px dashed rgb(205,205,205)"> 
     <div style="word-wrap:break-word; zoom:1; line-height:36px"> 
      <p style="word-wrap:break-word; margin-top:0px; margin-bottom:0px; padding-top:0px; padding-bottom:0px; float:right"> <a style="word-wrap:break-word; color:rgb(51,51,51); padding-right:16px; white-space:nowrap; margin-right:6px" rel="nofollow">使用道具</a>&nbsp;<a style="word-wrap:break-word; color:rgb(51,51,51); margin-right:6px" rel="nofollow">举报</a></p> 
      <span style="word-wrap:break-word; float:right"><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=2&amp;tid=298746&amp;repquote=8985796&amp;extra=page%3D1&amp;page=1" style="word-wrap:break-word; color:rgb(51,51,51); padding:5px 10px 5px 0px" rel="nofollow">回复</a></span> 
     </div> 
    </div> </td> 
  </tr> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255); background:rgb(255,255,255); padding:0px; height:4px"> &nbsp;</td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px; background:rgb(255,255,255); overflow:hidden"> &nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; background-color:rgb(241,241,241); table-layout:fixed; width:1284px"> 
 <tbody style="word-wrap:break-word"> 
  <tr style="word-wrap:break-word"> 
   <td style="word-wrap:break-word; vertical-align:top; width:160px; overflow:hidden; border-right:1px solid rgb(255,255,255)"> 
    <div style="word-wrap:break-word; vertical-align:top; width:160px; overflow:visible; border-width:0px; border-right-style:solid; border-right-color:rgb(255,255,255); background:transparent; height:auto; top:-136px; position:fixed"> 
     <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px 10px 15px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
      <div style="word-wrap:break-word"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=9340716" style="word-wrap:break-word; color:rgb(51,51,51); font-weight:700" rel="nofollow">seamanczg1984</a> 
      </div> 
     </div> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; margin:10px 15px"> 
       <a href="http://www.itpub.net/home.php?mod=space&amp;uid=9340716" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow"><img src="http://passport.ixpub.net/images/noavatar_middle.gif" alt="" style="word-wrap:break-word; border:none; width:120px; height:auto; padding:5px 5px 8px"></a> 
      </div> 
     </div> 
     <dl style="word-wrap:break-word; margin:5px 10px 5px 20px; padding:0px; zoom:1">
       论坛徽章: 
      <dd style="word-wrap:break-word; margin:0px; padding:0px; float:left; overflow:hidden; height:1.6em; line-height:1.6em; width:70px">
        8 
      </dd> 
     </dl> 
     <div style="word-wrap:break-word; padding:3px; margin-left:5px; margin-right:5px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2007-2small.gif" width="24px" alt="会员2007贡献徽章日期:2007-09-26 18:42:10" title="会员2007贡献徽章日期:2007-09-26 18:42:10" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/home_small.gif" width="24px" alt="ITPUB新首页上线纪念徽章日期:2007-10-20 08:38:44" title="ITPUB新首页上线纪念徽章日期:2007-10-20 08:38:44" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-10small.gif" width="24px" alt="生肖徽章2007版:鸡日期:2008-01-02 17:35:53" title="生肖徽章2007版:鸡日期:2008-01-02 17:35:53" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-09small.gif" width="24px" alt="生肖徽章2007版:猴日期:2008-01-02 17:35:53" title="生肖徽章2007版:猴日期:2008-01-02 17:35:53" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-01small.gif" width="24px" alt="生肖徽章2007版:鼠日期:2008-01-02 17:35:53" title="生肖徽章2007版:鼠日期:2008-01-02 17:35:53" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2008newyear_small.gif" width="24px" alt="2008新春纪念徽章日期:2008-02-13 12:43:03" title="2008新春纪念徽章日期:2008-02-13 12:43:03" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2009_niu_small.gif" width="24px" alt="2009新春纪念徽章日期:2009-01-04 14:52:28" title="2009新春纪念徽章日期:2009-01-04 14:52:28" style="word-wrap:break-word; margin:2px"> 
      <img src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/10years_small.gif" width="24px" alt="ITPUB十周年纪念徽章日期:2011-11-01 16:23:26" title="ITPUB十周年纪念徽章日期:2011-11-01 16:23:26" style="word-wrap:break-word; margin:2px"> 
     </div> 
    </div> </td> 
   <td style="word-wrap:break-word; vertical-align:top; padding:0px 20px"> 
    <div style="word-wrap:break-word; overflow:hidden; margin-bottom:10px; padding:10px 0px; height:16px; border-bottom:1px dashed rgb(205,205,205)"> 
     <span style="word-wrap:break-word"><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=298746&amp;pid=8985837" style="word-wrap:break-word; color:rgb(51,51,51); float:right; margin-top:-6px; padding:4px 6px; font-weight:400" rel="nofollow"><span style="word-wrap:break-word">10</span><sup style="word-wrap:break-word">#</sup></a></span> 
     <div style="word-wrap:break-word"> 
      <div style="word-wrap:break-word; float:right; margin:-5px 10px 0px 0px"> 
      </div> 
      <div style="word-wrap:break-word"> 
       <img src="http://www.itpub.net/static/image/common/online_member.gif" alt="" style="word-wrap:break-word; vertical-align:middle; width:16px">&nbsp; 
       <span style="word-wrap:break-word">发表于 2007-11-15 21:59</span>&nbsp; 
       <span style="word-wrap:break-word; margin:0px 5px; color:rgb(204,204,204)">|</span>&nbsp; 
       <a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=298746&amp;page=1&amp;authorid=9340716" style="word-wrap:break-word; color:rgb(51,51,51)" rel="nofollow">只看该作者</a> 
      </div> 
     </div> 
    </div> 
    <div style="word-wrap:break-word; padding-bottom:1em"> 
     <div style="word-wrap:break-word; clear:left; margin-right:0px"> 
      <div style="word-wrap:break-word; min-height:100px; color:rgb(68,68,68); font-family:Tahoma,&quot;Microsoft Yahei&quot;,Simsun"> 
       <table style="word-wrap:break-word; empty-cells:show; border-collapse:collapse; table-layout:fixed; width:1083px"> 
        <tbody style="word-wrap:break-word"> 
         <tr style="word-wrap:break-word"> 
          <td style="word-wrap:break-word; font-size:14px"> SQL&gt; select id,code from test1 where id=10;<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> Execution Plan<br style="word-wrap:break-word"> ----------------------------------------------------------<br style="word-wrap:break-word"> Plan hash value: 2428865550<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> --------------------------------------------------------------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> | Id&nbsp;&nbsp;| Operation&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;| Name&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;| Rows&nbsp;&nbsp;| Bytes | Cost (%CPU)| Time&nbsp; &nbsp;&nbsp;&nbsp;|<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> --------------------------------------------------------------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> |&nbsp; &nbsp;0 | SELECT STATEMENT |&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; |&nbsp; &nbsp;&nbsp;&nbsp;1 |&nbsp; &nbsp; 25 |&nbsp; &nbsp;&nbsp;&nbsp;2&nbsp; &nbsp;(0)| 00:00:01 |<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> |*&nbsp;&nbsp;1 |&nbsp;&nbsp;INDEX RANGE SCAN| IND_ID_CODE |&nbsp; &nbsp;&nbsp;&nbsp;1 |&nbsp; &nbsp; 25 |&nbsp; &nbsp;&nbsp;&nbsp;2&nbsp; &nbsp;(0)| 00:00:01 |<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> --------------------------------------------------------------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> <br style="word-wrap:break-word"> Predicate Information (identified by operation id):<br style="word-wrap:break-word"> ---------------------------------------------------<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> &nbsp; &nbsp;1 - access("ID"=10)<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> Note<br style="word-wrap:break-word"> -----<br style="word-wrap:break-word"> &nbsp; &nbsp;- dynamic sampling used for this statement<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> SQL&gt;<br style="word-wrap:break-word"> 如果这么写就是INDEX RANGE SCAN了，<br style="word-wrap:break-word"> 估计oracle看到sql是只查询id,code这两个字段，index中正好已经包括这两个字段，因此不用scan table了。但是上面一个查询条件是code用不到index 的key因此使用了full index scan，而这个的查询条件是id用到了key，因此使用了index range scan，实际上这两个是不一样的<br style="word-wrap:break-word"> <br style="word-wrap:break-word"> 个人认为，建index的目的是为了让oracle使用index range scan。个人愚见，望大佬指正。</td> 
         </tr> 
        </tbody> 
       </table> 
      </div> 
      <div style="word-wrap:break-word; color:rgb(68,68,68); font-family:Tahoma,&quot;Microsoft Yahei&quot;,Simsun"> 
      </div> 
      <div style="word-wrap:break-word; color:rgb(68,68,68); font-family:Tahoma,&quot;Microsoft Yahei&quot;,Simsun"> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>