ITPub博客

首页 > Linux操作系统 > Linux操作系统 > index clustering factor

index clustering factor

原创 Linux操作系统 作者:fenglixiang 时间:2010-09-13 14:40:48 0 删除 编辑
啥叫index clustering factor,一直不懂,在oracle的一篇文章中http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/optimops.htm#i82005提到:
Oracle does I/O by blocks. Therefore, the optimizer's decision to use full table scans is influenced by the percentage of blocks accessed, not rows. This is called the index clustering factor. If blocks contain single rows, then rows accessed and blocks accessed are the same.
 

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

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

注册时间:2009-02-19

  • 博文量
    47
  • 访问量
    92827