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