Effective MySQL Optimizing SQL Statements (Oracle Press)

Effective MySQL Optimizing SQL Statements (Oracle Press)

<h4><p class="MsoNormal"><span style="font-size:12.0pt;line-height:107%;font-family:"Times New Roman",serif">Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, <span style="white-space:pre"></span>authenticity, or access to any online entitlements included with the product.<o:p></o:p></span></p></h4><h4><br></h4><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><li>Learn how different index theories are applied and represented in MySQL</li><li>Plan and execute informed SQL optimizations</li><li>Create MySQL indexes to improve query performance</li><li>Master the MySQL query execution plan</li><li>Identify key configuration variables that impact SQL execution and performance</li><li>Apply the SQL optimization lifecycle to capture, identify, confirm, analyze, and optimize SQL statements and verify the results</li><li>Improve index utilization with covering indexes and partial indexes</li><li>Learn hidden performance tips for improving index efficiency and simplifying SQL statements</li></ul>