Tuesday, March 19, 2024

Optimizing SQL Statements

The first book of the Effective MySQL series provides the reader with the tools, knowledge and tips necessary for optimizing SQL Statements in MySQL.Effective MySQL: Optimizing SQL Statements by Ronald Bradford

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
  • much more…

Chapters

  1. The Five Minute DBA – Code ExamplesDownload Sample Chapter (PDF)
  2. The Essential Analysis Commands – Code Examples
  3. Understanding MySQL Indexes – Code Examples
  4. Creating Indexes – Code Examples
  5. Creating Better Indexes – Code Examples
  6. MySQL Configuration Options – Code Examples
  7. The SQL Lifecycle – Code Examples
  8. Hidden Performance Tips – Code Examples
  9. Explaining the MySQL Explain – Code Examples

Buy Now

This title is available in print, and ebook formats from these retailers.


Get the Code

In addition to the individual chapter links provided above you can download all SQL examples via github with the following command.

$ git clone git://github.com/effectiveMySQL/OptimizingSQLStatements.git

Other Titles

See other titles in our series including:

Related Presentations

You may also like these related presentations:

Comments

  1. ronald says:

    In the news at ITNewsCast.

Trackbacks

  1. OurSQL Episode 60: Charming Data…