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.