The Essential Guide to SQL Statement Optimization

Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements 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.

• Identify the essential analysis commands for gathering and diagnosing issues


• Learn how different index theories are applied and represented in MySQL


• Plan and execute informed SQL optimizations


• Create MySQL indexes to improve query performance


• Master the MySQL query execution plan


• Identify key configuration variables that impact SQL execution and performance


• Apply the SQL optimization lifecycle to capture, identify, confirm, analyze, and optimize SQL statements and verify the results


• Improve index utilization with covering indexes and partial indexes


• Learn hidden performance tips for improving index efficiency and simplifying SQL statements