This content is not currently approved and is visible here for review only.

Effective MySQL Optimizing SQL Statements (Osborne ORACLE Press Series)

Effective MySQL Optimizing SQL Statements (Osborne ORACLE Press Series)
Authors
Ronald Bradford
ISBN
0071782796
Published
19 Oct 2011
Purchase online
amazon.com

The Essential Guide to SQL Statement OptimizationWritten 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 performance. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements.

Editorial Reviews

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 performance. 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

You might also like...

Comments

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“It works on my machine.” - Anonymous