February 2025
M T W T F S S
« Jul    
 12
3456789
10111213141516
17181920212223
2425262728  

Loose index scan vs. covered indexes in MySQL

Loose index scan in MySQL can really help optimizing “group by” queries in some cases (for example, if you have only min() and/or max() as your aggregate functions). For example, if you have this query (to find maximum delay for all US flights with departure on Sundays in 2010):

select max(DepDelayMinutes), carrier, dayofweek from ontime_2010 […]