Tag

Index Skip Scan

1 views collected around this technical thread.

Top Architect

Aug 28, 2021 · Databases

MySQL 8.0 Index Enhancements: Function Indexes, Index Skip Scan, Descending Indexes, and Invisible Indexes

This article explains MySQL 8.0's new indexing features—including function indexes via virtual columns, Index Skip Scan for non‑leftmost predicates, descending indexes to avoid filesort, and invisible indexes for optimizer control—providing examples and usage guidelines.

Database OptimizationDescending IndexFunction Index

0 likes · 8 min read

MySQL 8.0 Index Enhancements: Function Indexes, Index Skip Scan, Descending Indexes, and Invisible Indexes

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

Understanding MySQL 8.0 Index Skip Scan (ISS)