I've blogged before about the new SQL synthax which is becoming available in databases and how it helps solving questions which are increasingly common.Now it's time for another example, something which doesn't come up often in a reporting environment as most tools have this feature, but can be a problem if you're building your output with a scipting language.Adding a "Total" row at the end of
Nov
02
2008
Jun
11
2008
First some of the things that you need to use and
understand
Explain Syntax
Order by Optimization
Group by Optimization
Update: Updated errors.
Now some details that are usually missed. GROUP BY does sorting
unless you tell mysql not to. GROUP BY has two optimization
methods, loose index scan, and tight index scan.
Loose index scan, scans the entire table index, while tight index
scan uses some sort of constraint. For large datasets that are
accessed often and require some sort of group by, tight index
scans are better.
So how to pick columns to create …