Read "SQL Tuning Generating Optimal Execution Plans" by Dan Tow available from Rakuten Kobo. Sign up today and get $5 off your first download. A poorly. SQL Tuning: Generating Optimal Execution Plans eBook: Dan Tow: sioteketerhost.ga: Kindle Store. Editorial Reviews. About the Author. Dan Tow is an independent consultant, operating under the banner SingingSQL (sioteketerhost.ga). His experience.
|Language:||English, Spanish, Portuguese|
|Distribution:||Free* [*Registration needed]|
SQL Tuning author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the . Author Dan Tow outlines a timesaving method he's developed for finding the optimum "SQL Tuning" concludes by addressing special concerns and unique . SQL Tuning provides an essential next step for SQL developers and database Author Dan Tow outlines a timesaving method he's developed for finding the.
Itzik Ben-Gan has been mentioned over times here on stackoverflow , but I couldn't believe it to find not a single mention of him here on this performance tuning question. As an additional resource, you can also find some videos of Itzik talking about performance related stuff here on youtube. What resources exist for Database performance-tuning? General SQL Book: SQL Tuning Book: Database tuning: PostgreSQL 9. Understanding Oracle Performance Book: Optimizing Oracle Performance Book: Troubleshooting Oracle Performance Book: What are the best SQL Server performance optimization techniques?
SQL Anywhere Book: Neil Kodner. You're lucky if you can find one. For Oracle, that person is Tom Kyte. Apr 8 '16 at This guy's answer to a not-the-same-inquiry is probably a good start.
Milen A. Quick PostgreSQL Optimization query optimizing Short read, explains a lot of things well and 'works' a real example which is nice for those of us that learn better that way. Nathan Voxland. SQL Server Resources. John Sansom. Christopher Klein.
Troubleshooting Oracle Performance Antognini Christian. Thomas Aregger. Gavin Miller. Matt Rogish. Here is another highly-regarded book that is platform-neutral: E-Rows is estimated rows.
A-Rows is actual rows. A-Time is actual time. Buffers is actual buffers.
For people working with Oracle I recommend this link Ian Carpenter. If you can commit all that to memory, most of the advice about tuning seems obvious. Tony Andrews. They are full of solid SQL advice: Dave Hilditch. Oracle sites 2 day performance tuning guide http: Featured on Meta. Unicorn Meta Zoo 3: How do we grade questions? O'Reilly Media; 1 edition 19 November Sold by: English ASIN: Enabled X-Ray: Not Enabled.
Customers who bought this item also bought.
Associate Exam. Joe Baron. Java Concurrency in Practice: Share your thoughts with other customers. Write a product review. Showing of 2 reviews.
Top Reviews Most recent Top Reviews. There was a problem filtering reviews right now. Please try again later. Paperback Verified download.
Lots of Information on how to tune the query! This is not the edition. See both reviews. Most helpful customer reviews on site.
Verified download. Like Dan, I have been doing Oracle for a long time since I offer three opinions about Dan's book: 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. As I said, I have been doing Oracle since And Dan explains it well. Unfortunately about the time Dan published the book , Oracle was entering a revolution in its design. 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.
Page 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. 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. 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 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 downloadd this book and you will be too. Hail Flavius! You have to read some paragraphs two or three times to understand what author wanted to say; 2. Why provide them then? What's the point of giving test db that can only be partially filled with data? The point is supposed to be in comparing the results and trying by yourself and not in trying somehow to match the result to the book and wondering why author gave you scripts that don't work; 4. And this form won't work in SQL server without alterations; 5.