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 the data, explains why things go wrong and how you can fix them when those ...
Read More
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 the data, explains why things go wrong and how you can fix them when those assumptions are incomplete, inaccurate, or simply false. He also includes a fabulous Upgrade Headaches section that is essential reading for anyone who has ever has, or ever will, upgrade between Oracle versions. Volumes 2 and 3 will track changes to the CBO in subsequent Oracle 10g releases, and will cover the more advanced and complex features of optimization.
Read Less
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $9.87, good condition, Sold by Goodwill of Greater Milwaukee rated 5.0 out of 5 stars, ships from Milwaukee, WI, UNITED STATES, published 2005 by Apress.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Book is considered to be in good or better condition. The actual cover image may not match the stock photo. Hard cover books may show signs of wear on the spine cover or dust jacket. Paperback book may show signs of wear on spine or cover as well as having a slight bend curve or creasing to it. Book should have minimal to no writing inside and no highlighting. Pages should be free of tears or creasing. Stickers should not be present on cover or elsewhere and any CD or DVD expected with the book is included. Book is not a former library copy.
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $10.09, new condition, Sold by KuleliBooks rated 5.0 out of 5 stars, ships from Phoenix, AZ, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals to cart. $10.71, very good condition, Sold by ThriftBooks-Reno rated 5.0 out of 5 stars, ships from Reno, NV, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals to cart. $10.71, very good condition, Sold by ThriftBooks-Dallas rated 5.0 out of 5 stars, ships from Dallas, TX, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals to cart. $10.71, very good condition, Sold by ThriftBooks-Baltimore rated 5.0 out of 5 stars, ships from Halethorpe, MD, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $12.00, good condition, Sold by HPB-Red rated 5.0 out of 5 stars, ships from Dallas, TX, UNITED STATES, published 2005 by Apress.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority!
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $28.72, new condition, Sold by CRS Trading rated 4.0 out of 5 stars, ships from Spring Valley, NY, UNITED STATES, published 2005 by Apress.