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

How to make MySQL using an index only by adding "order by"
Even LIKE can use an index in SQL. It depends on the wildcard.
Window Function - an old SQL standard that is now available in MySQL

Used Versions

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