Knockout Narratives Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | December 8, 2014

    Marina Warner: IMG How Is Fantasy Different from Fairy Tale?

    Fairy tale is a country of the mind where there are many inhabitants stretching back into deep time, and we're like people before Babel, we speak a... Continue »

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Computers Reference- General

Effective MySQL Optimizing SQL Statements (Osborne Oracle Press)


Effective MySQL Optimizing SQL Statements (Osborne Oracle Press) Cover


Synopses & Reviews

Publisher Comments:

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

Book News Annotation:

This small technical guide for database administrators provides detailed information on the optimizations of SQL statements and the troubleshooting and maintenance of running database processes. Beginning with a section on identifying performance problems and query optimization, the volume covers the essential database analysis commands, MySQL indexes, MySQL configuration options, the SQL lifecycle and advanced and hidden performance tips. Chapters include numerous code examples and access to additional online resources is provided. Bradford is an experienced database administrator and MySQL expert. Annotation ©2011 Book News, Inc., Portland, OR (

Product Details

Bradford, Ronald
McGraw-Hill/Osborne Media
Computers-Reference - General
Publication Date:

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » MySQL
Computers and Internet » Database » SQL
Computers and Internet » Networking » General
Computers and Internet » Software Engineering » Software Management
Engineering » Communications » Telephony
Health and Self-Help » Self-Help » General
Science and Mathematics » Electricity » General Electronics

Effective MySQL Optimizing SQL Statements (Osborne Oracle Press) New Trade Paper
0 stars - 0 reviews
$37.00 In Stock
Product details pages McGraw-Hill/Osborne Media - English 9780071782791 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at