- Home
- Computers
- Data Modeling & Design
- Effective MySQL Optimizing SQL Statements
Effective MySQL Optimizing SQL Statements
List Price:
$49.00
- Availability: Confirm prior to ordering
- Branding: minimum 50 pieces (add’l costs below)
- Check Freight Rates (branded products only)
Branding Options (v), Availability & Lead Times
- 1-Color Imprint: $2.00 ea.
- Promo-Page Insert: $2.50 ea. (full-color printed, single-sided page)
- Belly-Band Wrap: $2.50 ea. (full-color printed)
- Set-Up Charge: $45 per decoration
- Availability: Product availability changes daily, so please confirm your quantity is available prior to placing an order.
- Branded Products: allow 10 business days from proof approval for production. Branding options may be limited or unavailable based on product design or cover artwork.
- Unbranded Products: allow 3-5 business days for shipping. All Unbranded items receive FREE ground shipping in the US. Inquire for international shipping.
- RETURNS/CANCELLATIONS: All orders, branded or unbranded, are NON-CANCELLABLE and NON-RETURNABLE once a purchase order has been received.
Product Details
Author:
Ronald Bradford
Format:
Paperback
Publisher:
McGraw Hill LLC (October 19, 2011)
Audience:
General/trade
ISBN-13:
9780071782791
ISBN-10:
0071782796
Weight:
8.96oz
Dimensions:
6" x 9" x 0.38"
Case Pack:
46
File:
McGrawHill-MH_ONIX_V30_US_onix30_all(26_05_26)-20260526.xml
Folder:
McGrawHill
As low as:
$37.73
List Price:
$49.00
Publisher Identifier:
P-MCGRAW
Discount Code:
A
Pages:
184
Pub Discount:
55
Imprint:
McGraw Hill
Overview
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
