SQL Tuning und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
  • Alle Preisangaben inkl. MwSt.
Nur noch 2 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
Menge:1
SQL Tuning (Classique Us) ist in Ihrem Einkaufwagen hinzugefügt worden
+ EUR 3,00 Versandkosten
Gebraucht: Gut | Details
Verkauft von Deal DE
Zustand: Gebraucht: Gut
Kommentar: Dieses Buch ist in gutem, sauberen Zustand. Seiten und Einband sind intakt.
Ihren Artikel jetzt
eintauschen und
EUR 6,50 Gutschein erhalten.
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Alle 2 Bilder anzeigen

SQL Tuning (Classique Us) (Englisch) Taschenbuch – 26. November 2003


Alle 2 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
Taschenbuch
"Bitte wiederholen"
EUR 39,53
EUR 29,60 EUR 21,96
8 neu ab EUR 29,60 4 gebraucht ab EUR 21,96
EUR 39,53 Kostenlose Lieferung. Nur noch 2 auf Lager (mehr ist unterwegs). Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.

Hinweise und Aktionen

  • Reduzierte Bestseller und Neuheiten: Entdecken Sie unsere vielseitige Auswahl an reduzierten Hörbüchern und englischen Büchern. Klicken Sie hier, um direkt zur Aktion zu gelangen.

Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Produktinformation

  • Taschenbuch: 336 Seiten
  • Verlag: O'Reilly & Associates; Auflage: 1 (26. November 2003)
  • Sprache: Englisch
  • ISBN-10: 0596005733
  • ISBN-13: 978-0596005733
  • Größe und/oder Gewicht: 17,8 x 2,1 x 23,3 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 189.338 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
  • Komplettes Inhaltsverzeichnis ansehen

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Synopsis

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications. There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use. Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned.

SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems." Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.

Über den Autor und weitere Mitwirkende

Dan Tow is an independent consultant, operating under the banner SingingSQL (www.singingsql.com). His experience solving Oracle-related performance problems goes all the way back to his 1989 hire by Oracle Corporation. During most of his tenure at Oracle, Dan focused on the performance of Oracle Applications, managing the performance group for that division. In this role, he found a fertile testing ground for his SQL tuning method applied to the huge set of complex SQL included in those applications, including both online SQL and diverse batch processes. In 1998, Dan left Oracle to lead performance for TenFold Corporation, where he applied the same methods to tuning questions on DB2, and SQL Server, and Sybase, as well as on Oracle. In 2002, Dan started his own business, SingingSQL, through which he offers diverse database-related tuning services, including SQL tuning and systematically analyzing load to learn which SQL should be tuned. He has introduced his SQL tuning method to over 1,000 people in short lectures, and now offers in-depth courses in the material, using this book as textbook. Dan has a Ph.D. in chemical engineering from the University of Wisconsin at Madison. He lives in Palo Alto, California, and can be reached at dantow@singingsql.com.

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Hier reinlesen und suchen:

Kundenrezensionen

5.0 von 5 Sternen
5 Sterne
1
4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
Siehe die Kundenrezension
Sagen Sie Ihre Meinung zu diesem Artikel

Die hilfreichsten Kundenrezensionen

8 von 10 Kunden fanden die folgende Rezension hilfreich Von Ein Kunde am 21. Dezember 2004
Format: Taschenbuch
Tow schafft das was allen anderen Optimierungsbüchern fehlt, er vermittelt die wichtigen Grundsätze und liefert dem Leser einen einfachen aber dennoch qualifizierten Einstieg in dieses Thema, ohne aber dabei Abstriche in der Tiefe zu machen.
Er beschäftigt sich mit allen gängigen Datenbanken (Oracle bis 10g, DB2, SQL Server von Microsoft) und zeigt dabei dem Leser welche Grundkonzepte es gibt und was man generell zu diesem Thema wissen sollte.
Der Zweite Teil des Buches besteht aus einer didaktisch wirklich sehr guten Einführung in eine von Ihm entwickelte Methode zur Optimierung von Anfragen mit Hilfe von einfachen Ausführungsplänen. Auch dieser Abschnitt steht für sich selbst und kann somit bei jeder Relationalen Datenbank benutzt werden.
Wer also wirklich die Optimierung von Anfragen im Allgemeinen verstehen möchte, sollte sich dieses Buch besorgen.
Kommentar War diese Rezension für Sie hilfreich? Ja Nein Feedback senden...
Vielen Dank für Ihr Feedback. Wenn diese Rezension unangemessen ist, informieren Sie uns bitte darüber.
Wir konnten Ihre Stimmabgabe leider nicht speichern. Bitte erneut versuchen

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 19 Rezensionen
77 von 77 Kunden fanden die folgende Rezension hilfreich
Quick solutions for difficult optimization problems 25. Januar 2004
Von Charles D. Simmons - Veröffentlicht auf Amazon.com
Format: Taschenbuch
"Tell me something I don't already know", that's what crosses my mind every time I pick up a new performance, tuning book. If you're like me, 90% of the content in any DBA book in the store is 'old hat'.
This book is refreshing. It doesn't waste time going over all of the stuff you learned years ago.
Knowing how to read an execution plan or when to pick a hash join over a nested loop join is not what this book is about. There are plenty of books on the market that cover basic, vendor specific, query tuning. I personally have about 20 of these books on my bookshelf here at home. (Over the years I've worked on Sybase, SQL Server, Informix XPS, & Oracle.)
Here's the deal...
Anyone who has worked with really big systems will eventually run into an optimization problem that seems to be unsolvable. You can try histograms, compressed key indexes, partitioning, pre-joined indexes, and materialized views, but you still can't get the performance that's being requested. For a DBA, it can be a very frustrating dilemma. This is especially true when you know from the data volume that you should be able to get there.
The truth is, optimizers can't always get the right solution, even with correct statistics. There are some good technical reasons why this is true, but that's out of scope for my review. In any case, that's where this book comes to the rescue. I feel that it gives you some insight into the optimization problem and tells you how to correct the problems that your optimizer can't figure out.
This book is NOT for use on 95% of your queries. Most optimizers will pick the correct access plan if the DBA does his/her job correctly and collects the appropriate statistics.
In my experience, I get two types of problems that I have trouble getting the optimizer to solve:
#1. Joining together a large number (8-14) of tables. At least 1 or 2 of the tables have over 30G of real data. By `real data', I mean that 30G of data is actually populated.
#2. Making high transaction queries read the fewest amount of buffers in order to get rid of latching problems.
After I read the first few diagramming chapters of this book, I thought I'd give it a try on a problem that was recently solved at work. I was surprised. It worked, and even with my clumsiness with the method, it only took me about 2 hours to get a solution. It took us about 3 days at work. Our trial and error solution was slightly better, than what I came up with using the author's method. However, it was so close that had I used his method, I most certainly would have gone on to another problem. (The author's solution was strange because I would never have solved the join order the way that he did. His solution actually had me pick the largest table, out of 10, to drive the query. I thought this was odd because my test query had some very good filters on smaller tables.)
These were the results per execution:
Optimizer - 100K buffers.
Trial & Error - 1700 buffers.
Book method (basic graphing) - 2000 buffers.
If I had known about this book, I could have solved this problem in a few hours. Instead it took several DBA's, a few day's time to come up with a solution that was only marginally better.
Since this method appeared to work so well for OLTP, I went back and looked at a very large OLAP query that I had worked on last year. I and several developers had spent days trying to get it to run faster. Even with the author's method, I still couldn't make it better, but I was happy to see that the join order picked by the optimizer was almost identical to what I had calculated using the book.
I plan on studying this guide over and over until I've memorized this method. I don't think it will solve every problem, but I think it gives you an edge over using experience alone.
Before you purchase this book...
Keep in mind, that SQL tuning is fundamentally *not a simple problem*, so readers should not buy the book expecting an easy list of simple tips and tricks. (If the problem was easy, the optimizer likely would have got it right in the first place, and you wouldn't be tuning!) The correct solution to the problem is fairly complex, as complex as it *needs* to be.
Also, it's not noted anywhere, but I gathered that the author assumes that the reader will have basic high school Algebra skills, and will have taken a basic statistics course in order to fully understand the reasoning behind the explanations. Although, Algebra and statistical knowledge are probably not necessary to learn the tuning method presented. I state this because I told a good friend about this book, and his first question was, "Does it have a lot of math to go through?" So, if statistics is not your thing, don't worry. The author only presents enough information to give you a level of comfort that his method is based on mathematics. He doesn't require that you know "graph theory" or anything like that.
By the way, our change from 100K buffers per transaction to 1700 buffers, dropped the CPU utilization for the website that was running the OLTP query by about 70%. That was on a 16 CPU, Sun/Solaris box. So proper SQL tuning can save you a lot of $$$.
21 von 21 Kunden fanden die folgende Rezension hilfreich
A Work of Genius 22. Juli 2006
Von Kurt Survance - Veröffentlicht auf Amazon.com
Format: Taschenbuch
I have withdrawn my earlier review because I did not properly understand the importance of this book until the second reading. That is a difficult admission to make since my business is database performance tuning.

This book is about tuning SQL queries in a systematic and scientific manner. It is above all about determining the optimum order in which the query engine should access the tables involved. My quibble was that join order is only a part of the whole tuning problem and most of the time the query optimizer got it right anyway. While this is true, I see now that it misses the point.

The fact that the optimizer gets it right so often allows us to take join order for granted. But how do we know the optimizer got it right unless we know what the optimum join order is? That is what this book teaches, a methodology and an elegant system of notation that allows us to determine the optimum join order of the most complex query. As the author points out, the number of possible join orders increases factorially with the number of tables involved. An 8 table join has 40,320 possible join orders. That rules out trial and error for all but the simplest queries.

It turns out that analyzing and diagramming according to Tow's method gives you a deep architectural understanding of the query and the problems that face you. It gives you a plan to which you can apply the tools of the trade, indexes, code optimization, etc.

This is a book that will be on the shelf of serious performance tuning professionals for as long as SQL is the language of data manipulation.
13 von 13 Kunden fanden die folgende Rezension hilfreich
This Old Dog learned a new trick 28. Juni 2010
Von Kevin Meade - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
Like Dan, I have been doing Oracle for a long time (since 1984). I offer three opinions about Dan's book:

1) learning how to do query diagrams is great for people who have never done them and this book is the best (maybe even the only) book for learning this. In learning to do the diagrams, you will understand the basic logic and basic math that an optimizer must do in order to get you a good plan. Do not worry. It is not a deep math book and there are no complex calculations. Indeed Dan shows you how basic it all really is. This gives you a deeper foundation in optimization and brings you closer to having that INFORMATIONAL CRITICAL MASS which is required to do good tuning.

2) the book is outdated. As I said, I have been doing Oracle since 1984. For two decades, Dan's method of tuning and relying mostly on NESTED LOOP JOIN was the only real game in town. And Dan explains it well. Unfortunately about the time Dan published the book (2003), Oracle was entering a revolution in its design. Most notably, databases were increasing in size dramatically and this made the need for PARTITIONING strategies and PARTITION WISE HASH JOINS very high. Dan's techniques of query diagraming are still useful for understanding a query's needs, but the book is today outdated because of its lack of treatement for PARTITIONING and HASH JOIN techniques. Don't get me wrong, even outdated, this book has great value because it clarifies what you need to tell other people, why certain things happened.

3) Even outdated, I learned one neat join trick which alone is worth the 20 dollars I paid for this book. Page 146 has a gem of a trick that I never considered but which I can see as offering massive benefits in a few special situations which I have faced in the past but could not solve. Thanks Dan. It is even easier to do in today's 10g and 11g databases because you need no hints to make it happen.

This brings me to my last commentary. The reason I say the book is outdated is because Oracle has come so far in the last five years with its optimizer that the trick to getting Oracle to give you the right plan is to feed it good information. If you do this then it will do what Dan shows you in this book (only better than you could) and give you a great if not best plan. Thus you will rarely build a query diagram these days. Instead you will try to figure out where information was not provided to Oracle correctly and fix that. If this turns out not to be the case, then the problem is likely because the SQL is crappy and you need to rewrite it. I would say that given the right information (stats collected right, constraints created for PK,UK,FK, indexes built to support the constraints, datatypes correct for columns, not null defined when data is actually required), Oracle will produce a great or best plan 99% of the time. The other 1% of the time you will 99% of the time be doing SQL rewrites. That leaves 1/100th of 1% of queries to be a real problem. Many times your system won't be that complicated.

Not being an expert in DB2 or Sql Server I cannot say how up-to-date the material remains on these databases but since I doubt their Optimizer Technology is as advanced as Oracle's there may yet be significant value retained in these two spaces. I can say that it is true that Dan's diagramming methods are universal for any database and that reading the book will provide you with that boost towards critical mass I mentioned earlier regardless of what database you use.

If you are an Oracle Developer/DBA and you are new to tuning, or want to see what you know and don't know, you can't go wrong by getting this book. After reading the book, start reading about PARTITIONING and PARTITION WISE HASH JOINS. Understanding what is in this book and understanding the details of PARTITIONING and PARTITION WISE HASH JOINS in various scenarios will put you at the forefront of tuners. Maybe its time for Dan to do an updated version of the book.

One last comment. I don't want this to seem like a negative review. Remember I said I have been doing Oracle since 1984. As "expert" as I am with Oracle and in tuning it (I am a reasonably good tuner for most things), I learned stuff from Dan and his book. Twenty Five years of doing it and this book still taught me things. I am very happy to have purchased this book and you will be too.

Hail Flavius!
11 von 11 Kunden fanden die folgende Rezension hilfreich
A "Must Have" book for DBA's and SQL Developers 27. Februar 2004
Von Brian H. Blades - Veröffentlicht auf Amazon.com
Format: Taschenbuch
For many years the process of SQL Tuning has been considered an "art". SQL tuning books written to date have presented guidelines and "things to try" but "SQL Tuning" by Dan Tow is different. This is the first book I have seen that presents a clear methodology to attack the problem in a scientific/mathematical way and includes a diagramming technique to visualize the components of a query that affect performance. Dan's book has gone a long way in helping to transform SQL tuning from an art to a science.
The first four chapters of the book cover some of the subjects that are found in other SQL tuning books, and focus on the important points without delving too deeply into database internals. The really "good stuff" is covered in chapters 5 through 10, which includes how to "draw" a query diagram, and the procedures to follow to derive an optimal join order. The problems/examples presented and resolved in these chapters help the reader get a start on understanding the methodology, which can then be applied to actual tuning problems as they are encountered.
So far I have applied this technique to about 20 tuning problems I have encountered on the job using the Oracle RDBMS. I still consider myself a relative novice in using the methodology, but for each of the 20 problems I have been able to significantly reduce elapsed time and resource consumption (gets/reads). Also, these results were achieved in a matter or hours, rather than days. The query diagram has even facilitated finding "missing joins" in some of the queries without having a knowledge of the particular application.
This book is a "must have" for DBA's and developers and I highly recommend it.
12 von 13 Kunden fanden die folgende Rezension hilfreich
Practical, exhaustive text 20. März 2004
Von Douglas Squirrel - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Disclaimer: I am the CTO of youDevise Ltd., a firm that distributes a product of the author's former employer, TenFold Corporation. I worked with him on performance tuning projects several years ago during his employment there.
I have been running high-volume performance tuning projects for the past four years, using both SQL Server and Oracle. Our products generate their SQL, so we cannot edit it; nevertheless, our job is to make that SQL run faster, normally with hints, indexes, and parameter changes.
I have observed Dan apply the method he describes in the book to help us resolve our performance problems, and it really does work as quickly and effectively as other reviewers describe. My teams and I have also tried tuning SQL ourselves, and _that_ is as difficult and ineffective as you might expect - on more than one occasion we've had to resort to hacks like denormalisation. The difference really is a few minutes versus several days.
After reading the book, I finally understand what Dan was doing that let him tune our SQL so effectively. The method is highly algorithmic - you follow a series of fairly simple steps to draw a graph and out pops a near-optimal query plan. Dan also describes how to influence your database to use the query plan you found with his method.
My team and I haven't had the chance to apply Dan's method yet, but it's very simple and I'm confident we will be able to do so. I plan to make the book required reading for the team before our next project.
My only complaint about the book - and it's quite a minor one - is that it doesn't cover open-source alternatives like mySQL or PostgreSQL. Applying the method to these alternative databases would be fairly simple, but coverage of the basics like identifying the query plan or influencing the optimiser would be nice to have under one cover.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.