SQL Query Patterns, Optimized
Mar 22, 2013
Percona Live University - Toronto
Bill Karwin, Principal MySQL Instructor
Let's get into several common types of queries that developers struggle with, showing SQL solutions, and then analyze them for optimal efficiency. I'll cover Exclusion Join, Relational Division, Greatest-Per-Group, Dynamic Pivot, and Random Selection.