Effective MySQL Optimizing SQL Statements

<h4>The Essential Guide to SQL Statement Optimization</h4><p>Written by Oracle ACE Director and MySQL expert Ronald Bradford <i>Effective MySQL: Optimizing SQL Statements</i> is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization this Oracle Press book helps you to analyze and tune problematic SQL statements.</p><ul><li>Identify the essential analysis commands for gathering and diagnosing issues<li>Learn how different index theories are applied and represented in MySQL<li>Plan and execute informed SQL optimizations<li>Create MySQL indexes to improve query performance<li>Master the MySQL query execution plan<li>Identify key configuration variables that impact SQL execution and performance<li>Apply the SQL optimization lifecycle to capture identify confirm analyze and optimize SQL statements and verify the results<li>Improve index utilization with covering indexes and partial indexes<li>Learn hidden performance tips for improving index efficiency and simplifying SQL statements</ul>