Book description
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
Table of contents
- Cover Page
- Title Page
- Copyright
- Contents
- Acknoledgements
- Introduction
- 1 The Five Minute DBA
- 2 The Essential Analysis Commands
- 3 Understanding MySQL Indexes
- 4 Creating MySQL Indexes
- 5 Creating Better MySQL Indexes
- 6 MySQL Configuration Options
- 7 The SQL Lifecycle
- 8 Hidden Performance Tips
- 9 Explaining the MySQL EXPLAIN
- Index
Product information
- Title: Effective MySQL Optimizing SQL Statements
- Author(s):
- Release date: October 2011
- Publisher(s): Oracle Press
- ISBN: 9780071782807
You might also like
book
SQL for MySQL Developers: A Comprehensive Tutorial and Reference
The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect MySQL version 5 …
book
MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
Know how locks work in MySQL and how they relate to transactions. This book explains the …
book
Effective MySQL Replication Techniques in Depth
The Essential Guide to Scaling Your Business Solution Written by Oracle ACE Director and MySQL expert …
book
Expert MySQL, Second Edition
Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks …