no detail and some mistake: The book never go deep into sql even the author promised to do so, it is not a step-by-step guild that dbas can follow, and the seasoned dba also do not need this book because of nothing new. You can see some obvious mistake in this book, for example, about the hash join, Mr. Burleson told us in the page 67 and page 391 that the hash table probe the large table, but oracle document said large table probes the hash table. I hope to see some detail about the analyse of execution plan of table join and scenario, but there is none.
Very helpful for optimizer tuning: I found this book to be exceptionally helpful for tuning SQL at the optimizer level. I was happy to see that the text contains complete explainations of the optimizer modes and the benefits of each. I also liked the technique for analyzing SQL from the library cache, and I have found this book to be very helpful.
This is a most excellent text: I bought a copy of this book in hopes of tuning the SQL in my Oracle8i database and I was not disappointed. When using the techniques in the book, I was able to quickly identify and tune the most resource intensive SQL statements in my system. The book is clear and easy to understand.
Good book for tuning complex SQL: I have a very complex system with lots of subqueries, and I was unable to find good tuning information until I tried the techniques in this book. The book is simple to understand and explains the internals of complex Oracle SQL operations. I have been very heppy with the results from my tuning, and I am thankful to find this textbook.
An excellent & clear book about the sql internals: It is an excellent book for those interested in the internals of sql. The knowledge of the author about the matter is excellent, and his style to write, clear, simple and funny.
| Author: | Donald K. Burleson | | Binding: | Paperback | | Dewey Decimal Number: | 005.7585 | | EAN: | 9780072190588 | | Edition: | 1 | | ISBN: | 0072190582 | | Number Of Pages: | 656 | | Publication Date: | 2001-07-27 | | UPC: | 783254037007 |
|