]]> ]]>

MySQL Query Patterns, Optimized

You are here

 

Join Bill Karwin, Percona’s Principal MySQL Instructor, as he classifies several common types of queries with which developers struggle, based on years of answering questions online. Bill will test several SQL solutions for each type of query objective, and show how you can use MySQL 5.6 built-in methods to analyze them for optimal query efficiency.  The discussion will cover optimizer reports, query profiling, and session status to measure performance.  The query classes include:

·         Exclusion Join

·         Random Selection

·         Greatest-Per-Group

·         Dynamic Pivot, and

·         Relational Division

WHEN: Friday, May 31, 2013

PRESENTER: Bill Karwin, Senior Knowledge Manager

Slides: Download Here

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
More Numbers
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>