A discovery – Index Condition Pushdown can cause a slowdown after all

(Sergey Petrunia) MariaDB 5.5 and then MySQL 5.6 got Index Condition Pushdown (ICP) optimization (initially coded by yours truly). The idea of ICP is simple: after reading the index record, check the part of WHERE condition that can be computed using index columns, and only then read the table recor

Read More - Register for Free Membership