Summer Reading B2G1 Free

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 | July 14, 2015

    Joshua Mohr: IMG Your Imagination, Your Fingerprint

    When I was in grad school, a teacher told our workshop that if a published novel is 300 pages, the writer had to generate 1,200 along the way. I... Continue »
    1. $17.50 Sale Hardcover add to wish list

      All This Life

      Joshua Mohr 9781593766030

Qualifying orders ship free.
List price: $37.00
Sale Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
2 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