You are here

Speed up GROUP BY queries with subselects in MySQL

MySQL Performance Blog - Mon, 15/06/2015 - 6:32pm

We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect? This example was tested over table a (1310723 rows), b, c and d ( 5 rows each) and with MySQL version 5.5 and 5.6. Let’s […]

The post Speed up GROUP BY queries with subselects in MySQL appeared first on MySQL Performance Blog.