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 20, 2019 · Databases

Understanding MySQL 8.0 Descending Indexes and Their Performance Impact

This article explains the new descending index feature in MySQL 8.0, compares its execution plans and resource usage against traditional ascending indexes, and provides practical examples and composite index strategies to improve query performance.

Descending IndexSQLdatabase

0 likes · 4 min read

Understanding MySQL 8.0 Descending Indexes and Their Performance Impact

Tencent Cloud Developer

May 5, 2019 · Databases

Handling ORDER BY When Index Order Differs and Using Descending Indexes in MySQL

MySQL can avoid a filesort for ORDER BY clauses that match an index’s direction by scanning the index forward or backward, and MySQL 8.0’s descending indexes let mixed‑direction sorts be satisfied similarly; for older versions you can emulate this by retrieving rows in index order and reversing groups in the application.

Descending IndexOrder Bydatabase

0 likes · 9 min read

Handling ORDER BY When Index Order Differs and Using Descending Indexes in MySQL