- We will send in 10–14 business days.
/images/books/11296619/9781590596364.jpg)
- Author: Jonathan Lewis
- Publisher: Apress
- Year: 2005
- Pages: 536
- ISBN-10: 1590596366
- ISBN-13: 9781590596364
- Format: 19.3 x 23.4 x 3.6 cm, minkšti viršeliai
- Language: English
- SAVE -10% with code: EXTRA
Reviews
Description
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.
EXTRA 10 % discount with code: EXTRA
The promotion ends in 21d.15:03:15
The discount code is valid when purchasing from 10 €. Discounts do not stack.
- Author: Jonathan Lewis
- Publisher: Apress
- Year: 2005
- Pages: 536
- ISBN-10: 1590596366
- ISBN-13: 9781590596364
- Format: 19.3 x 23.4 x 3.6 cm, minkšti viršeliai
- Language: English English
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.
Reviews