ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Clustered Index Scan and Clustered Index Seek

Clustered Index Scan and Clustered Index Seek

原创 Linux操作系统 作者:tolywang 时间:2009-05-12 16:18:43 0 删除 编辑

Clustered Index Scan and Clustered Index Seek for Clustered Index :  

   Index Seek means that SQL Server  will traverse the index  from the root down to the leaf level, comparing
the values in the SARG to the key values in the index rows to determine which page to look at next.  Seeking 
through an index typically means a root-to-leaf traversal.  

      Index scan,  the alternative to Index Seek, means that SQL Server will stay at the leaf level and traverse just that
one level of the index from the first page to the last. I like to think of a seek as a vertical traversal of an
index and a scan as a horizontal  traversal.    Remember that for a clustered index, the leaf level of the index is
the table data itself, so scanning the clustered index really means scanning  the table.  In fact, the only time you'll
see Table Scan as an operator in the plan is for heaps.

Clustered Index Scan  相当于全表扫描

Clustered Index Seek  相当于索引扫描

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-600856/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Too many open files
请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13306658