ITPub博客

首页 > Linux操作系统 > Linux操作系统 > index full scan 和 index FAST full scan 区别

index full scan 和 index FAST full scan 区别

原创 Linux操作系统 作者:sxitsxit 时间:2012-05-14 11:13:24 0 删除 编辑

index full scan starts at the root block, walks down the branches on the left
hand side one by one till it gets to the first leaf block on the "left" and then
reads the index one block at a time -- leaf by leaf.  it reads the data
"sorted".

index FAST full scan reads the extent map for the index and using multi-block IO
reads the index in big chunks.  It throws out all root/branch blocks and
processes the data it finds on the leaf blocks.  It reads the data "in some
random order".


So a FAST full scan would generally read the index faster due to the multiblock
IO.

好帖,学习一下

帖子原文出处: http://www.itpub.net/thread-346360-2-1.html 

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

请登录后发表评论 登录
全部评论

注册时间:2011-04-14

  • 博文量
    98
  • 访问量
    293451