Skip to content
Tagged articles

Skip Scan

4 articles · Page 1 of 1
java1234
java1234
Oct 9, 2026 · Databases

PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More

PostgreSQL 18.6 introduces async I/O with io_uring support, skip scan for composite indexes, time-ordered UUIDv7, virtual generated columns, OAuth authentication, RETURNING old/new values, and critical security fixes for logical decoding and pgcrypto.

GIN IndexGenerated ColumnsOAuth
0 likes · 15 min read
PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More
Senior Tony
Senior Tony
Jul 20, 2024 · Databases

How MySQL’s Skip Scan Defies the Leftmost Prefix Rule

This article explains MySQL’s composite index leftmost‑prefix rule, demonstrates how the Skip Scan Range Access Method introduced in MySQL 8.0.13 can use indexes without following the rule, provides step‑by‑step examples, code snippets, and discusses its implementation, benefits, and limitations.

Composite IndexMySQLSQL
0 likes · 10 min read
How MySQL’s Skip Scan Defies the Leftmost Prefix Rule
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.14Indexing
0 likes · 9 min read
Key Improvements in MySQL 8.0.13 and 8.0.14