你的位置:首页 > 软件开发 > 数据库 > MySQL索引下推技术

MySQL索引下推技术

发布时间:2016-02-18 11:00:06
索引下推整个思路如下:To see how this optimization works, consider first how an index scan proceeds when Index Condition Pushdown is not used:Get the n ...

索引下推整个思路如下:

To see how this optimization works, consider first how an index scan proceeds when Index Condition Pushdown is not used:

  1. Get the next row, first by reading the index tuple, and then by using the index tuple to locate and read the full table row.

  2. Test the part of the WHERE condition that applies to this table. Accept or reject the row based on the test result.


原标题:MySQL索引下推技术

关键词:MYSQL

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。