Zhuanzhuan Tech

Nov 5, 2025 · Databases

Why MySQL Chooses Full Table Scan Over Index: Uncovering Cost Constant Secrets

This article examines a puzzling MySQL case where the optimizer selects a full‑table scan despite suitable indexes, explains the role of cost constants, execution‑plan analysis, and demonstrates how to force the optimizer to use the optimal index for faster queries.