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索引结构原理、性能分析与优化 (阅读:14631)
- 浅谈MySQL索引背后的数据结构及算法 (阅读:9655)
- 由浅入深理解索引的实现(2) (阅读:6112)
- HBase二级索引与Join (阅读:5637)
- 如何建立合适的索引? (阅读:5145)
- InnODB和MyISAM索引统计集合 (阅读:4988)
- Innodb 表和索引结构 (阅读:4605)
- mysql查询中利用索引的机制 (阅读:4427)
- MySQL索引背后的数据结构及算法原理 (阅读:4292)
- 多维度分类排行榜应用:用位图索引 (阅读:3951)
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:Incessant 来源: Incessant
- 标签: 索引
- 发布时间:2009-10-11 22:24:35
- [110] WEB系统需要关注的一些点
- [16] 浏览器的工作原理:新式网络浏览器幕后揭秘
- [12] Spark性能优化——和shuffle搏斗
- [12] 一次神奇的MySQL优化
- [12] 我的git笔记
- [11] Android设计中的.9.png
- [11] InnoDB insert性能拐点测试
- [11] Python 代码规范小结
- [11] 内网穿透神器frp
- [10] Python程序的执行原理