Cost-Based Oracle Fundamentals

Name: Cost-Based Oracle Fundamentals
Availability: InStock
ISBN: 9781590596364

ISBN-10: 1590596366

ISBN-13: 9781590596364

Edition: 2006

Authors: Jonathan Lewis

List price: $69.99

30 day, 100% satisfaction guarantee!

Rent eBooks

30 day rental: $18.00 Expiration date: 5/25/2024

60 day rental: $24.00 Expiration date: 6/24/2024

90 day rental: $30.00 Expiration date: 7/24/2024

120 day rental: $36.00 Expiration date: 8/23/2024

Marketplace

2 new & used from $6.53

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

The insights that Jonathan provides into the workings of the cost-based optimizer will make a DBA a better designer, and a Developer a better SQL coder. Both groups will become better troubleshooters-- Thomas Kyte, VP (Public Sector), Oracle Corporation 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 columnsemdash; 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…

Book details

List price: $69.99
Copyright year: 2006
Publisher: Apress L. P.
Publication date: 1/24/2007
Binding: Paperback
Pages: 536
Size: 7.00" wide x 9.25" long x 1.09" tall
Weight: 1.848

Jonathan Lewis made award-winning documentary films for thirty years. He, his wife and their dog now split their time between a cottage in Oxfordshire and an old motor yacht. This is his second novel.



What do you mean by cost?


Single table selectivity


Simple B-Tree access


The clustering factor


Selectivity issues


Histograms


Bitmap indexes


Query transformation


Join cardinality


Nested loops


Hash joins


Sorting & merge joins


The 10053 trace file