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. $21.79, new condition, Sold by Gulf Coast Books rated 5.0 out of 5 stars, ships from Memphis, TN, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $25.82, 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 (Expert's Voice in to cart. $26.22, new condition, Sold by CRS Trading rated 3.0 out of 5 stars, ships from Spring Valley, NY, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals to cart. $49.52, new condition, Sold by Ingram Customer Returns Center rated 5.0 out of 5 stars, ships from NV, USA, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $56.88, new condition, Sold by Just one more Chapter rated 3.0 out of 5 stars, ships from Miramar, FL, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $72.99, new condition, Sold by Russell Books rated 4.0 out of 5 stars, ships from Victoria, BC, CANADA, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $73.36, new condition, Sold by GridFreed rated 5.0 out of 5 stars, ships from North Las Vegas, NV, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals (Expert's Voice in to cart. $74.46, new condition, Sold by Bonita rated 4.0 out of 5 stars, ships from Santa Clarita, CA, UNITED STATES, published 2005 by Apress.
Add this copy of Cost-Based Oracle Fundamentals to cart. $82.38, new condition, Sold by Booksplease rated 4.0 out of 5 stars, ships from Southport, MERSEYSIDE, UNITED KINGDOM, published 2005 by Apress.
