The Super Fun Kids' Graphic Novel 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 | September 21, 2015

    Annie Jacobsen: IMG Mirrors on the Moon: A Reporter's Story about Sources and Secrets in the Modern World

    As a national security reporter, I write about war, weapons, security, and secrets. The question most commonly asked of me is, "How do you get... Continue »
    1. $21.00 Sale Hardcover add to wish list

Qualifying orders ship free.
List price: $37.00
Sale Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Database- Applications

More copies of this ISBN

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) Sale Trade Paper
0 stars - 0 reviews
$5.98 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