Su San Talks Tech

Apr 14, 2022 · Databases

How MySQL Uses Indexes for GROUP BY: Compact vs Loose Scans Explained

This article explains how MySQL can implement GROUP BY using either a compact index scan that reads rows sequentially or a loose index scan that jumps to the needed rows, compares their costs, and shows when each method is optimal, including a hybrid sequential‑loose scan.