BestHub
search
Sign in
Tag

Skip Scan

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 2, 2021 · Databases

Why MySQL Chooses a Composite Index Even When the Query Skips the Leftmost Column

This article explains why MySQL may still use a composite index as a covering or range index despite the query not following the leftmost‑prefix rule, by analyzing optimizer trace output and demonstrating the behavior with concrete experiments.

Covering IndexDatabase PerformanceSkip Scan
0 likes · 3 min read
Why MySQL Chooses a Composite Index Even When the Query Skips the Leftmost Column
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 23, 2019 · Databases

Key Improvements in MySQL 8.0.13 and 8.0.14

This article reviews the most notable enhancements introduced in MySQL 8.0.13 and 8.0.14, covering query speed optimizations, the new Skip Scan access method, changes to index design rules, deprecated features, and several operational and security improvements for database administrators and developers.

8.0.138.0.14Database Optimization
0 likes · 9 min read
Key Improvements in MySQL 8.0.13 and 8.0.14