Index Full Scans和Fast Full Index Scans的区别
Index Full Scans
A full scan is available if a predicate references one of the columns in the index. The predicate does not need to be an index driver. A full scan is also available when there is no predicate, if both the following conditions are met:All of the columns in the table referenced in the query are included in the index.At least one of the index columns is not null.
A full scan can be used to eliminate a sort operation, because the data is ordered by the index key. It reads the blocks singly.
Fast Full Index Scans
Fast full index scans are an alternative to a full table scan when the index contains all the columns that are needed for the query, and at least one column in the index key has the NOT NULL constraint. A fast full scan accesses the data in the index itself, without accessing the table. It cannot be used to eliminate a sort operation, because the data is not ordered by the index key. It reads the entire index using multiblock reads, unlike a full index scan, and can be parallelized.
Fast full scan is available only with the CBO. You can specify it with the initialization parameter OPTIMIZER_FEATURES_ENABLE or the INDEX_FFS hint. Fast full index scans cannot be performed against bitmap indexes.
A fast full scan is faster than a normal full index scan in that it can use multiblock I/O and can be parallelized just like a table scan.
建议继续学习:
- 由浅入深探究mysql索引结构原理、性能分析与优化 (阅读:14648)
- 浅谈MySQL索引背后的数据结构及算法 (阅读:9663)
- 由浅入深理解索引的实现(2) (阅读:6123)
- HBase二级索引与Join (阅读:5645)
- 如何建立合适的索引? (阅读:5153)
- InnODB和MyISAM索引统计集合 (阅读:4995)
- Innodb 表和索引结构 (阅读:4615)
- mysql查询中利用索引的机制 (阅读:4440)
- MySQL索引背后的数据结构及算法原理 (阅读:4301)
- 多维度分类排行榜应用:用位图索引 (阅读:3959)
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:Incessant 来源: Incessant
- 标签: 索引
- 发布时间:2009-10-11 22:24:35
- [12] Python连接 MySQL 数据库的超时问
- [12] 产品设计之QQ邮箱登录页与淘宝登录页
- [10] 手机客户端交互适配设计之我见
- [10] 一个 VLA (可变长度数组)的实现
- [9] 没有比解决瓶颈更高效的事情了
- [9] 一句话crontab实现防ssh暴力破解
- [9] 谈谈Facebook的聊天系统架构
- [8] 触摸屏手机交互设计
- [8] 四年前的今天,我开始找工作
- [8] PDC 2010:C#与Visual Bas