Tag: Open Source

Community

UNION vs UNION ALL Performance

(Peter Zaitsev) When I was comparing performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I should be using UNION ALL instead of simple UNION in my benchmarks, and he was right. Numbers would be different but it should not change general point of having optimization of moving L

Community

JOINs VS ENUMs

(Tim Soderstrom) So last week MySQL was on site at work for MySQL DBA Certification prep. class (which was very awesome and highly recommended, by the way) and one of the things that came up was how much faster enumerated types would be over using JOINs, say to store things like the categories of a