BestHub
Sign in
Tagged articles

Index Pushdown

4 articles · Page 1 of 1
Shepherd Advanced Notes
Shepherd Advanced Notes
Mar 22, 2023 · Databases

Mastering MySQL Indexes: Advanced Concepts and Practical Tips

This article provides a comprehensive deep‑dive into MySQL indexing, covering the definition, pros and cons, differences between clustered and non‑clustered indexes, InnoDB vs MyISAM implementations, B+Tree structure, capacity calculations, adaptive hash indexes, index pushdown optimization, and how to interpret EXPLAIN output to verify index usage.

Adaptive Hash IndexB+TreeClustered Index
0 likes · 18 min read
Mastering MySQL Indexes: Advanced Concepts and Practical Tips
ITPUB
ITPUB
Apr 30, 2021 · Databases

How Index Pushdown Cuts Unnecessary Table Lookups in MySQL

This article explains MySQL's table‑lookup (回表) process, the difference between primary‑key and secondary indexes, and how the index‑pushdown feature introduced in MySQL 5.6 reduces unnecessary lookups by filtering rows directly in the index.

Index PushdownInnoDBTable Lookup
0 likes · 7 min read
How Index Pushdown Cuts Unnecessary Table Lookups in MySQL