Cost-Based Oracle Fundamentals

by Jonathan Lewis

Jonathan Lewis is one of the world's foremost authorities in this field (he is frequently quoted and reference by other leading experts, such as Tom Kyte – see for example Book will be strongly co-promoted with Tom Kyte's Expert Oracle Database Architecture (1-59059-530-0) Highlights traps for those migrating from Oracle 8i to 9i to 10g, potentially averting often disastrous performance issues and downtime (=lost revenue) The first comprehensive book written to investigate, describe, and demonstrate the methods used by the Cost Based Optimizer Jonathan is one of very few Oracle authors to maintain online enhancements, errata and addenda pages, so the reader will be supported long after the book is published

536 pages, Paperback

First published November 1, 2005

Reviews

[Michael Finocchiaro · Rating 5 out of 5]

Hands-down, the BEST book about how Oracle's complex optimiser works. The title says "volume 1" and I met Lewis at Oracle OpenWorld a few years back and he confirmed my suspicions that writing this book was so hard, he was too exhausted to write a sequel. It is difficult but an excellent source of information. When you realize that Oracle has as many patents and programmers for their optimiser as Microsoft has for their Windows operating system, you get an idea of the titanic work it required to write this extraordinary book!

[Colin Hoad · Rating 5 out of 5]

Nobody (including those who programmed it themselves) understands the Oracle CBO better than Jonathan Lewis. If you want to make sense out of how and why Oracle chooses to execute queries in the way that it does, read this book. It is dense, complicated material but Lewis nevertheless does his utmost to make it both clear and comprehensive.

[Daniel Galassi · Rating 4 out of 5]

After asking myself why some of the data models were performing so badly I realised I had to read this book (sure, among others). But this was the first book about cost-based optimisation I was able to read from cover to cover... and understand how to use the myriad of features Oracle databases have to offer.
The authors know CBO extremely well and the book is written in a way that a good developer (doesn't need to be a seasoned or expert) will take huge advantage of.

[Neil · Rating 4 out of 5]

Currently reading for work. I wish there was a good place to get reviews of technical manuals hopefully my review will help.

[Corrado Piola · Rating 5 out of 5]

I read it a lot of time ago. Really a must! Optimizer internals in great detail.