Cost-Based Oracle Fundamentals
| Price | $6.33 - $44.54
|
| Rating |  |
| Author | Jonathan Lewis |
| Publisher | Apress |
| Published | 2005 |
| Pages | 536 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1590596366 |
| ISBN-13 | 9781590596364 |
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 columns - 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 watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. You'll come to know how the optimizer thinks, understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL.
The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.
In Cost-Based Oracle Fundamentals, the first book in a series of three, Jonathan Lewis - one of the foremost authorities in this field - describes the most commonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, you'll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.
Chapter 5:
→ https://itbook.store/files/9781590596364/chapter5.pdf
Source Code:
→ https://itbook.store/files/9781590596364/sourcecode.zip
- Jonathan Lewis (2 books)
5 5 99
Similar Books
Oracle SQL Tuning Pocket Reference 
by Mark Gurry
One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the r...
Price: $6.76 | Publisher: O'Reilly Media | Release: 2002
by Tony Hasler
Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systemat...
Price: $58.31 | Publisher: Apress | Release: 2014
by Anthony Nocentino, Ben Weissman
Build a modern data platform by deploying SQL Server in Kubernetes. Modern application deployment needs to be fast and consistent to keep up with business objectives and Kubernetes is quickly becoming the standard for deploying container-based applications, fast. This book introduces Kubernetes and its core concepts. Then it shows you how...
Price: $45.93 | Publisher: Apress | Release: 2021
BlackBerry Development Fundamentals
by John M. Wargo
The BlackBerry smartphone is today's #1 mobile platform for the enterprise and also a huge hit with consumers. Until now, it's been difficult for programmers to find everything they need to begin developing new applications for BlackBerry devices. BlackBerry Development Fundamentals is the solution: the first single-source guide...
Price: $4.17 | Publisher: Addison-Wesley | Release: 2010
Oracle PL/SQL Language Pocket Reference, 4th Edition
by Steven Feuerstein, Bill Pribyl, Chip Dawes
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL inf...
Price: $5.98 | Publisher: O'Reilly Media | Release: 2007
Oracle Certified Professional Java SE 7 Programmer Exams 1Z0-804 and 1Z0-805
by S G Ganesh, Tushar Sharma
Oracle Certified Professional Java SE 7 Programmer Exams 1Z0-804 and 1Z0-805 is a concise, comprehensive, step-by-step, and one-stop guide for the Oracle Certified Professional Java SE 7 Programmer Exam. The first two chapters set the stage for exam preparation and let the reader get started quickly. The first chapter answers frequently ...
Price: $5.01 | Publisher: Apress | Release: 2013
Beginning Oracle Application Express 4.2, 2nd Edition
by Doug Gault, Karen Cannell, Patrick Cimolini, Martin Giffy D'Souza, Timothy St. Hilaire
Beginning Oracle Application Express 4.2 introduces version 4.2 of the popular and productive Oracle Application Express development platform. Called APEX for short, the platform enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 4.2 brings extensive new Flash and HTML 5...
Price: $24.99 | Publisher: Apress | Release: 2013
Oracle Database 12c Performance Tuning Recipes
by Sam Alapati, Darl Kuhn, Bill Padfield
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to le...
Price: $46.46 | Publisher: Apress | Release: 2013