SQL Performance Explained Everything Developers Need to Know about SQL Performance

From a developer perspective, this book provides an excellent overview. It does a bit of glossing over some topics such as bind variables. For example, it does not go into the details on how bind variables are handled by Oracle 11. However, it at least concisely explains the high-level concepts and the potential issues. This book is the minimum that a developer should know when working with Oracle. It feels like this book was written by a developer because the author gets to the point and is concise. He says what should be said in one sentence or one page versus wordy authors that might take several pages or an entire chapter to say the same thing. Almost like working with a development tech lead who has good communication skills. The PDF version of this book is not free. Meaning, you have to purchase it: extra cost beyond the price of buying the printed book. I typically only buy kindle books. This is the one rare instance I purchased a print-only book because I thought I would get a PDF file for free. Only having the print version of this book is going to make it difficult to use as a continuous reference, and so I'll buy the PDF version from the author's web site. This is the first time I can recall having to pay for the PDF version of a book. Today, I only care about Oracle, and so the sections that describe how the other databases work are not useful to me. I also do not use an ORM tool, and so the sections on ORMs are also not useful to me. However, if you are going to write a SQL book with the focus being "developers" then I can see how these other sections can be potentially useful to any developer who is working with SQL. Overall, it is a great book to help a developer get quickly started with SQL performance.

This book is good, really good. Optimizing SQL, writing performant queries, is something that every developer dealing with databases ought to know how to do but it is not something taught in any SQL class I've seen or, if it is, it's always either taught steeped in an RDBMS-specific way that makes the knowledge difficult to apply to other databases or so academically that it's hard to know how any of it applies. This book covers SQL in general but, importantly, makes it concrete by providing examples in *multiple* popular databases. It also takes the time to explain peculiarities of different implementations, by which I mostly mean Oracle, which is something all general SQL tutorials seem to avoid. Although nothing in here was a revelation to me for a lot of people it will be, and even I found nuggets of usefulness despite having a decade of experience in database performance tuning. This book lays out in simple, clear terms the things you need to know and is written in sufficiently non-arcane language that even an entry level developer should be able to follow it. I am certainly going to use this book as my way of explaining query optimization to all future developers I must teach, because it expresses these ideas far more lucidly than I have been able to manage. 5/5, would gather statistics again

To begin with I should point out that I was given the book by the author and promised to review it. The author has however had no insight into the contents of this review and have made no attempts whatsoever to influence it. With a title like "SQL Performance Explained" it might seem strange that the book is less than 200 pages long. Don't let the page count fool you though, this book does a very good job of covering a lot of ground. The small tip boxes scattered around the pages alone have more valuable content than many other books. The author is well known for his expertise on indexing and that obviously shines through in the book, but the topics discussed are not at all limited to indexing. The wide set of topics covered include efficient indexing and querying, join algorithms, execution plans as well as the anatomy of indexes. Care is also taken to discuss how data volumes affect query performance and database scalability. The focus of the writing is very much geared towards developers, many chapters include code samples in many common languages apart from the SQL. The book covers specifics about the major four database engines which is as much a strength as it is a potential weakness. Anyone interested only in database X might think this book is too broad, which would be unfortunate. While most readers probably focus on their database of choice and skip over sections on the competing ones it is never a bad idea to learn more about the competition. Not to mention the great fit it is for consultants who see a wide array of environments on different assignments. To conclude, this book is vital for any database developer, DBA as well as anyone interested in database performance. It's unlikely to be the only book in your professional library but is highly likely to be one that sticks in your memory and that you read cover to cover. It is highly likely to be your go to book. The promise the title gives is held, SQL performance is explained

E' un libricino che si legge velocemente contenente tanti dettagli e consigli sull'utilizzo degli indici dei database relazionali (in particolare il libro si riferisce maggiormente ad Oracle). Davvero una bella (ed interessante) lettura!

This is a very good, but very technical book! If you want to understand what is going on behind the scenes, understand things like how Indexing, and even the order in which you create indexes can drastically impact performance, ... this book will enlighten you. I do not think this book is for a beginner though, simply too advanced. SQL Performance Explained

before: 'Hmm, I need to do the thing with the data'; hack together SQL in Squirrel until it gives the correct answer; copy SQL into program; think 'it worked in dev and test' when it turns out to be horribly slow in production; sprinkle indexes; see moderate improvements; leave alone. now: 'Hmm, I need to do the thing with the data'; write SQL to get data, bearing in mind table indexes, join criteria, and the ease with which the database optimiser will be able to narrow down to the target data; run explain plans and check costs; remember that I need real data volumes for the explain plans to be representative of production, and repeat; copy SQL into program; never hear about it again. And all in less than two hundred pages which--while they could be quickly summarised as 'use indexes effectively'--don't waste any time with history lessons, edge-cases, or other forms of padding. Throughout this, it still manages to highlight the differences between Oracle, SQL Server, MySQL and PostgreSQL. I can't really offer any criticism here, hence the five stars, but if there is ever going to be a follow up then I'd like to see some coverage of DB2.

Super Buch. Es hat mir bei der Arbeit schon so einige Male weitergeholfen. Ohne viel unnötiges Rauschen bringt der Autor das Essentielle, was für den Entwickler wichtig ist auf den Punkt und hilft mit praktischen und anschaulichen Beispielen.

Ich denke, es müsste günstiger zu haben sein... Inhaltlich supi.