Aikesheng Open Source Community
May 7, 2019 · Databases
Understanding MySQL 8.0 Index Skip Scan (ISS)
MySQL 8.0 introduces Index Skip Scan (ISS), allowing queries that filter on non‑leftmost columns of a composite index to use the index without creating additional indexes, improving performance especially when the leftmost column has few distinct values, as demonstrated with example tables and execution plans.
Database OptimizationISSIndex Skip Scan
0 likes · 4 min read