or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
32 used & new from £15.00
Have one to sell? Sell yours here
 
   
Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle)
 
 
Share your own customer images
Search inside this book

Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle) (Paperback)

by Jonathan Lewis (Author)
5.0 out of 5 stars  See all reviews (10 customer reviews)
RRP: £39.49
Price: £23.72 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £15.77 (40%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 4 left in stock--order soon (more on the way).

Want guaranteed delivery by Thursday, February 11? Choose Express delivery at checkout. See Details
21 new from £20.70 11 used from £15.00

Frequently Bought Together

Customers buy this book with Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Osborne Oracle Press Series) by Richmond Shee

Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle) + Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Osborne Oracle Press Series)
Price For Both: £41.66

Show availability and delivery details

Customers Who Bought This Item Also Bought

Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions

Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions

by Thomas Kyte
4.2 out of 5 stars (4)  £22.33
Troubleshooting Oracle Performance, Hardback

Troubleshooting Oracle Performance, Hardback

by Christian Antognini
5.0 out of 5 stars (1)  £36.87
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Osborne Oracle Press Series)

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Osborne Oracle Press Series)

by Richmond Shee
5.0 out of 5 stars (1)  £17.94
Effective Oracle by Design (Osborne Oracle Press Series)

Effective Oracle by Design (Osborne Oracle Press Series)

by Thomas Kyte
5.0 out of 5 stars (4)  £20.99
Oracle PL/SQL Programming

Oracle PL/SQL Programming

by Steven Feuerstein
4.3 out of 5 stars (20)  £29.14
› Explore similar items

Product details

  • Paperback: 536 pages
  • Publisher: APRESS (1 Oct 2005)
  • Language English
  • ISBN-10: 1590596366
  • ISBN-13: 978-1590596364
  • Product Dimensions: 23.1 x 17.8 x 2.8 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon.co.uk Sales Rank: 249,112 in Books (See Bestsellers in Books)

    Popular in this category:

    #77 in  Books > Computing & Internet > Databases > Oracle

    •  Would you like to update product info or give feedback on images?

  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
   Discounted Oracle Pricing opens new browser window
www.awaretechnologies.com  -  Oracle licensing experts. Unbiased advice/discount prices 866-712-9273
   Oracle Apps R12 Courses opens new browser window
vault.oraclecontractors.com  -  Oracle Training Courses HR, Payroll, Financials, DBA R12
   StayAhead Training opens new browser window
www.stayahead.com  -  Scheduled and Onsite courses for DBA's Developers & Users
  
 

Product Description

Product Description

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong? If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. You'll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL. The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect. In Cost-Based Oracle Fundamentals, the first book in a series of three, Jonathan Lewis--one of the foremost authorities in this field--describes the most commonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, you'll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.
Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
 
oracle
sql
cbo
oracle statistics
oracle optimizer
optimizer
db
databases
database
cost based optimizer
cost based

Your tags: Add your first tag
 
See most popular tags

What Do Customers Ultimately Buy After Viewing This Item?

Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle)
79% buy the item featured on this page:
Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle) 5.0 out of 5 stars (10)
£23.72
Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions
10% buy
Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions 4.2 out of 5 stars (4)
£22.33
Effective Oracle by Design (Osborne Oracle Press Series)
6% buy
Effective Oracle by Design (Osborne Oracle Press Series) 5.0 out of 5 stars (4)
£20.99
Troubleshooting Oracle Performance, Hardback
3% buy
Troubleshooting Oracle Performance, Hardback 5.0 out of 5 stars (1)
£36.87
Explore similar items
 

Customer Reviews

10 Reviews
5 star:
 (10)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (10 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
19 of 19 people found the following review helpful:
5.0 out of 5 stars This book is exceptional, 22 Nov 2005
It's my favourite Oracle book of the many I've read and I'm not expecting it to be surpassed any time soon.

This book takes takes a complex and essential component of the Oracle architecture, the Cost Based Optimiser, and teaches it from the basics up to the complex using an elegant tutorial style. Jonathan doesn't stint on the deep detail that's necessary to understand the subject but he doesn't baffle you with science either. You might need to read it a little more slowly and carefully than you would some third-party Oracle books and play around with the plentiful small examples (which are all available online) but that's because you're getting enough information to justify the purchase cost (and much more) and you know when you get to the end that you'll understand the subject *properly*. With that understanding, it'll be much easier to work out why the CBO is doing something that you've never seen it do before. As always with technical subjects, everything springs from the fundamentals.

No matter what your involvement with Oracle is, you can not avoid the optimiser. I bet you there'll be plenty of people in Oracle Support with this book on their desk!

If you think you're a serious Oracle professional, you should
own this book, devour the contents and experience plenty of those moments when the lights go on and you think - 'Oh, right, so *that's* why it does that'. That includes DBAs who'll learn something new about how their decisions on free lists, block sizes and so on can affect application performance. I can't imagine that there is anyone out there who won't learn something new from this book and you'll finally be able to take a *structured approach* to solving CBO problems instead of just guessing.

I think this book is an absolute classic among books about Oracle and that it’s the only book you'll ever need to truly understand the cost based optimiser (apart perhaps for Volumes Two and Three that will cover more specialised subjects).

Buy it - you won't be disappointed.

Help other customers find the most helpful reviews  
Was this review helpful to you? Yes No


 
9 of 9 people found the following review helpful:
5.0 out of 5 stars deep and detailed, yet surprisingly easy to follow, 12 Jun 2006
By Alberto Dell'era (Milan, Italy) - See all my reviews
(REAL NAME)   
Outstanding and excellent book - and I'm saying this after six months of reading and re-reading, and running and studying the provided scripts, and even performing my own investigations starting from the book's test cases.

It has been surprisingly easy to understand the material, even if I didn't know most of the things discussed. Reading has flown seamlessly, not exactly like reading a novel, but close enough for a technical book about the very complex CBO - and that was something I didn't expect at all, a very very nice surprise.

The most fundamental topics (the first ones are selectivity, cardinality, etc) being right at the beginning, I didn't need to read the whole book to start using the new knowledge effectively in practice, thus getting the "morale boost" that motivated me to read the next chapter, and then the next ... adding layer after layer of knowledge.

I also *loved* the high level of detail, which is absolutely necessary to understand the complex CBO, and the precise and succinct writing style as well, which makes for an easier and quicker learning. When speaking about mathematical subjects (since the CBO is just that of course - a mathematical model), it's mandatory to be precise and detailed: vague statements would only add confusion or, worstly, misunderstanding.

To recap - I've got home a vastly improved understanding of the CBO - and for a fraction of the effort I thought it would have taken.
Help other customers find the most helpful reviews  
Was this review helpful to you? Yes No


 
5 of 5 people found the following review helpful:
5.0 out of 5 stars Cost–Based Oracle Fundamentals – Jonathan Lewis, 12 Dec 2005
By K.E.Pearce (Berkshire, United Kingdom) - See all my reviews
As a DBA I was really looking forward to reading this book and I wasn't disappointed. It is perhaps, a little hard-going in places, but this is not at all surprising as the subject it covers is complex.
I thought the book was well structured and very well written. Each chapter contained lots of detailed information, plenty of interesting examples and a list of downloadable scripts to illustrate the text.
All in all, I thought this was an excellent book and a very useful and comprehensive reference. It comes highly recommended and definitely deserves a place on my Oracle bookshelf.
Help other customers find the most helpful reviews  
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Essential Read
If you want to understand and I mean really understand the oracle CBO, beg borrow or steal this book. Read more
Published 16 months ago by Daniel Mclean Fisher

5.0 out of 5 stars Best ever Oracle book
This is the best ever oracle book I have read. What was interesting for me the way the test scripts where written down isolating each and every aspects that make up complex task... Read more
Published on 10 Oct 2007 by A. K. Kollan Vas

5.0 out of 5 stars Invaluable resource for all Oracle Professionals
Great book for anyone looking for a deeper understanding of how Oracle chooses the best access path to the data.
Published on 6 July 2007 by Manu Alphonse

5.0 out of 5 stars Fantastic coverage of the CBO.
If you are an Oracle DBA interested in Oracle performance, then this is the book for you. I have been a DBA for more than 9 years, and have read many books on the subject of... Read more
Published on 24 May 2007 by S. Forgie

5.0 out of 5 stars Fundaments for the Advanced
The title of this book may lead some to believe this is a book for beginners. Think again! This is the most advanced and detailed Oracle book I have read. Read more
Published on 19 May 2007 by A. G. Hasler

5.0 out of 5 stars BEST EVER
This book is the best book ever, in my view, Tom's "Expert Oracle" has no comparsion to this one. If you want to be a serious Oracle developer or DBA, this book is definitely a... Read more
Published on 20 July 2006 by Zhongquan Mao

5.0 out of 5 stars Cost–Based Oracle Fundamentals – Jonathan Lewis
As a DBA I was really looking forward to reading this book and I wasn't disappointed. It is perhaps, a little hard-going in places, but this is not at all surprising as the... Read more
Published on 14 Dec 2005 by K.E.Pearce

Only search this product's reviews


Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

   

Listmania!

Create a Listmania! list

Look for similar items by category

Look for similar items by subject
















i.e., each product must be in subject 1 AND subject 2 AND ...

Feedback


Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.