Prevent a temporary DB table caused by SQL group by

Code

-- tested with MySQL 5.6

-- Missing index. Filesort and tmp table using more memory
EXPLAIN SELECT name, status, SUM(price)
  FROM history
    GROUP BY name, status;

-- index (name, status)
EXPLAIN SELECT name, status, SUM(price)
  FROM history
  GROUP BY name, status;

Result

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	history	null	ALL	null	null	null	null	1407	100	Using temporary

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	history	null	index	name_status_idx	name_status_idx	771	null	1407	100	null

More Snippets

Instead of MySQL's IFNULL function, this works on PostgreSQL, Sqlite and others too
Doing math in SQL can ignore indices
SQL Row-Value constructor in a Where-clause

Used Versions

PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8