Index Condition Pushdown

Selected Java Interview Questions

May 20, 2025 · Databases

Understanding Index Condition Pushdown (ICP) in MySQL: Theory, Usage, and Performance Comparison

Index Condition Pushdown (ICP) is a MySQL 5.6 feature that pushes part of WHERE filtering to the storage engine, reducing row reads and I/O; this article explains its principles, activation, usage examples, performance testing, and conditions under which ICP can be applied.

Database OptimizationICPIndex Condition Pushdown

0 likes · 10 min read

Understanding Index Condition Pushdown (ICP) in MySQL: Theory, Usage, and Performance Comparison

Cognitive Technology Team

Mar 28, 2025 · Databases

Index Condition Pushdown (ICP) Optimization in MySQL

Index Condition Pushdown (ICP) is a MySQL query‑optimization technique that pushes eligible WHERE predicates to the storage engine so that index entries can filter rows early, reducing row fetches and server‑engine communication.

Index Condition PushdownMySQLQuery Optimization

0 likes · 5 min read

Index Condition Pushdown (ICP) Optimization in MySQL

Aikesheng Open Source Community

Nov 30, 2022 · Databases

Understanding Index Condition Pushdown (ICP) in MySQL and Its Impact on Query Cost

Index Condition Pushdown (ICP) in MySQL pushes filter conditions to the storage engine to reduce row lookups, but this article demonstrates through experiments that while ICP lowers runtime by decreasing back‑table accesses, the optimizer’s cost model often ignores its benefits, leading to suboptimal plan choices.

Index Condition PushdownMySQLQuery Optimization

0 likes · 10 min read

Understanding Index Condition Pushdown (ICP) in MySQL and Its Impact on Query Cost

Tencent Database Technology

Oct 27, 2022 · Databases

Analysis of Unexpected InnoDB Lock Waits Caused by Missing End‑Range Push‑Down and Semi‑Consistent Reads

The article explains why a seemingly non‑conflicting UPDATE on a secondary index can cause lock‑wait alerts under RC isolation, detailing the missing end‑range condition push‑down, the InnoDB row‑search flow, semi‑consistent read behavior, and differences between primary‑key and secondary‑index locking.

Database InternalsIndex Condition PushdownInnoDB

0 likes · 12 min read

Analysis of Unexpected InnoDB Lock Waits Caused by Missing End‑Range Push‑Down and Semi‑Consistent Reads

Aikesheng Open Source Community

Apr 21, 2021 · Databases

Understanding MySQL Index Condition Pushdown (ICP) and Its Performance Benefits

Index Condition Pushdown (ICP) in MySQL 5.6 optimizes secondary index scans by pushing filter conditions to the storage engine, reducing row lookups and data transfer, with examples showing performance gains, usage guidelines, EXPLAIN checks, and limitations.

Database OptimizationICPIndex Condition Pushdown

0 likes · 10 min read

Understanding MySQL Index Condition Pushdown (ICP) and Its Performance Benefits

Java Captain

Apr 12, 2019 · Databases

Understanding MySQL Indexes in InnoDB: Structures, Types, and Optimization Techniques

This article explains MySQL indexes—defining what they are, classifying them by structure, storage, and logic, illustrating InnoDB clustered and secondary index structures with examples, and covering advanced concepts such as covering indexes, the leftmost‑prefix rule, and index condition pushdown to improve query performance.

Database IndexesIndex Condition PushdownInnoDB

0 likes · 10 min read

Understanding MySQL Indexes in InnoDB: Structures, Types, and Optimization Techniques