SQL Query Patterns, Optimized

Mar 22, 2013

Percona Live University - Toronto

Bill Karwin, Senior Knowledge Manager

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.