Programming Books C Java PHP Python Learn more Browse Programming Books
Qty:1
  • List Price: $59.99
  • Save: $27.79 (46%)
FREE Shipping on orders over $35.
Only 6 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
SQL Performance Tuning has been added to your Cart
Want it tomorrow, Oct. 9? Order within and choose One-Day Shipping at checkout. Details
FREE Shipping on orders over $35.
Used: Good | Details
Sold by tamarbooks
Condition: Used: Good
Comment: Paperback in good condition. Text is clean, cover shows moderate wear.
Access codes and supplements are not guaranteed with used items.
Other Sellers on Amazon
37 used & new from $3.57
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Performance Tuning Paperback – September 20, 2002

ISBN-13: 978-0201791693 ISBN-10: 0201791692 Edition: 1st

Buy New
Price: $32.20
15 New from $19.00 22 Used from $3.57
Amazon Price New from Used from
Paperback
"Please retry"
$32.20
$19.00 $3.57
Free%20Two-Day%20Shipping%20on%20College%20Essentials


Frequently Bought Together

SQL Performance Tuning + SQL Tuning
Price for both: $59.74

Buy the selected items together
  • SQL Tuning $27.54

Customers viewing this page may be interested in these sponsored links

  (What's this?)
  -  
Boost your SQL Server Performance at Affordable - Get a free Quote
  -  
Predictable Database Performance. Accelerate SQL Processing by 12x!
  -  
Write, edit and explore SQL effortlessly. Download a free trial
See a problem with these advertisements? Let us know

NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 528 pages
  • Publisher: Addison-Wesley Professional; 1 edition (September 20, 2002)
  • Language: English
  • ISBN-10: 0201791692
  • ISBN-13: 978-0201791693
  • Product Dimensions: 0.9 x 7.2 x 9 inches
  • Shipping Weight: 1.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon Best Sellers Rank: #1,506,160 in Books (See Top 100 in Books)


More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.6 out of 5 stars
5 star
8
4 star
0
3 star
2
2 star
0
1 star
0
See all 10 customer reviews
This book, SQL Performance Tuning, has proved to be one of the most invaluable books in my reference collection of SQL books.
Teddy N. Johnston
Throughout this book the authors present and test techniques for improving SQL performance, and grade the technique for its usefulness on the major DBMSs.
Data Guy
I have not read most of it yet, but I am very excited about what I will find in the rest of it, even if it is something that I think I know well.
uniq

Most Helpful Customer Reviews

23 of 25 people found the following review helpful By Dmitry Dvoinikov on January 26, 2006
Format: Paperback
This book is rather controversial. I'll begin with a quote from the preface:

QUOTE

...we've written it for users and programmers who want to improve SQL performance, no matter what brand of SQL they use. In this book, you'll find tuning tips for common situations... Rather than exploiting the unique features of a single DBMS, we're going to give you ideas that are good for all of the major SQL DBMSs.

END QUOTE

Sounds good, but !

The biggest idea behind this book is that the authors took 8 most common databases (as per 2002: DB2, Informix, Ingres, Interbase, MS SQL, MySQL, Oracle, Sybase) and sort of compared them on many different subjects. I said "sort of" because you won't find specific recommendations like "DB2 does this better", or "this makes the query faster on Oracle". Instead, the authors came up with this idea - upon each discussed topic they summarize the gain that you might possibly get from using that particular technique should you be using it on _all_ of the 8 databases. They put it like:

GAIN: x/8

which means that with the discussed trick in place, x out of 8 databases performed better (and the rest showed no improvement).

Two things make it break - (1) there is only so many tricks that improve on most databases (it's commonly 3/8) and (2) there is no way to tell which of 8 showed an improvement.

And so, how does it help me as a database administrator and developer ? I only work with 2, may be 3 specific database servers and there is no way to tell whether _they_ gained from that trick or not. All I can do is to keep all tricks in mind, apply them all anyway and hope it was my database that had an improvement. Or, I can re-run tests and see for myself.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By David W. Smith on March 26, 2003
Format: Paperback
There's a lot of ground to cover between being able to put together a SQL query that runs and being able to construct a query that works well. The journey is all the more complicated when you're trying to target multiple RDBMSes, each with its own nuances and oddities. That's where this book shines. By going for breadth--picking 8 major RDMBS and contrasting how they behave in the face of various SQL constructs and optimizations, plus covering some general theory, this book conveys a quality of information that vendor-specific books lack. I knew a fair amount about databases and SQL before picking up the book, and came away with a much better feeling for the terrain, and a new set of optimization tricks.
It's unfortunate, but perhaps unavoidable, that some details (e.g. lack of information on transactions and subselects in MySQL) where out-of-date by the time the book was published. It's also unfortunate that the authors were prevented by vendor license agreements from providing performance hard numbers.
Don't get this book to learn how to optimize for a particular vendor's database. Study it to broaden your skills.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By MajorTom on September 30, 2002
Format: Paperback
I've just finished chapter 7 and 15. The book offers quite interesting information. It's written very well and easy to understand. Plus a special sense of humor ;-)
The information gathered must not be used immediately, but helps when making decisions on database design and usage. This is because, you gain an overview on what the "big eight" do, thus you better understand what your decision could mean, when switching databases.
It's a book suitable for both experts and beginners, though basic sql knowledge is expected.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 10 people found the following review helpful By uniq on April 30, 2003
Format: Paperback
Over the years I've developed a number of systems that utilized relational databases. When I developed or used a complex and/or large database, more often than not I found that database performance was the main issue, especially in real-time or near real-time applications. I have been interested in the databases *only* to the point of satisfying my projects' needs and considered them subordinate to the rest of the systems. I did realize the complexity of RDBMSs implementations, but never cared to learn more than I necessary to solve an immediate problem at hand. Maybe this is why I've never really enjoyed reading about the databases: I believed that the databases and SQL were quite boring comparing to all the elegance and slickness of C++, Java, CORBA, and other object-oriented technologies.

"SQL Performance Tuning" changed my perception of that; I was hooked just after just a few sentences. The language, the obvious depth of the authors' knowledge, the wide and careful coverage of all related issues, including the very fundamentals of the relational databases are presented as needed; and mostly, the enjoyably right balance between the theory and practice makes this book an outstanding read. I have not read most of it yet, but I am very excited about what I will find in the rest of it, even if it is something that I think I know well.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Philip K Gunning on July 26, 2004
Format: Paperback
This is one of the few SQL books that has practical examples and addresses DB2, Informix, SQL Server, and Oracle. It contains excellent facts on how SQL is processes, which one must understand to write top performing SQL. The authors accomplished just that with this excellent book. You'll get hard to find details on query optimizers, B+tree index structures and many myths you have had will be demystified...
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
 

Feedback

If you have a question or problem, visit our Help pages.
 Would you like to update product info or give feedback on images?
If you are a seller for this product and want to change product data, click here (you may have to sign in with your seller id).


Your Recently Viewed Items and Featured Recommendations 
 

After viewing product detail pages, look here to find an easy way to navigate back to pages you are interested in.