Cost-Based Oracle Fundamentals

by Jonathan Lewis and Thomas Kyte

Book Overview

In this book, volume 1 in a series of three, Jonathan covers the fundamentals: the things that everyone who uses the Oracle database needs to know about the CBO. It sheds light on the decisions the CBO makes when parsing a SQL statement and choosing an access plan. It demonstrates how the CBO calculates the cost of a plan and the rules and factors that go into these calculations. It reveals the basic assumptions the optimizer makes about the SQL and...

• Format: Paperback
• Language: English
• ISBN: 1590596366
• ISBN13: 9781590596364
• Release Date: November 2005
• Publisher: Apress
• Length: 536 Pages
• Weight: 1.95 lbs.
• Dimensions: 1.4" x 7.6" x 9.2"