Java Backend Technology

Nov 7, 2019 · Databases

Mastering MySQL COUNT: When to Use *, COUNT(1), or Column Names

This article explains the different forms of MySQL's COUNT function, compares COUNT(*), COUNT(1) and COUNT(column), reveals engine‑specific optimizations for MyISAM and InnoDB, and provides guidance on which form to use in practice.