Cost-Based Oracle Fundamentals



Bookstore > Books > Cost-Based Oracle Fundamentals

Price$6.33 - $57.90
Rating
AuthorJonathan Lewis
PublisherApress
Published2005
Pages536
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101590596366
ISBN-139781590596364
EBook Hardcover Paperback

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.


  1. (2 books)



4 5 73

Similar Books


Oracle SQL Tuning Pocket Reference

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

Expert Oracle SQL

Expert Oracle SQL

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

SQL Server on Kubernetes

SQL Server on Kubernetes

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:  $44.99  |  Publisher:  Apress  |  Release:  2021

Oracle PL/SQL Language Pocket Reference, 4th Edition

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 PL/SQL Programming, 6th Edition

Oracle PL/SQL Programming, 6th Edition

by Steven Feuerstein, Bill Pribyl

Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle's powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.Hundreds of thousands of PL/SQL developer...

Price:  $50.42  |  Publisher:  O'Reilly Media  |  Release:  2014

Beginning Oracle Application Express 5, 3rd Edition

Beginning Oracle Application Express 5, 3rd Edition

by Doug Gault

Whether you're new to Oracle or an old hand who's yet to test the waters of APEX, Beginning Oracle Application Express 5 introduces the processes and best practices you'll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking thr...

Price:  $33.82  |  Publisher:  Apress  |  Release:  2016

Pro jQuery in Oracle Application Express

Pro jQuery in Oracle Application Express

by Scott Wesley

Building on your existing SQL skills, this book teaches you how to apply useful jQuery techniques to applications developed using the Oracle Application Express (APEX) development tool.Pro jQuery in Oracle Application Express covers the fundamentals you need to start enhancing your applications, with some practical examples that you'...

Price:  $38.67  |  Publisher:  Apress  |  Release:  2015

Practical Oracle SQL

Practical Oracle SQL

by Kim Berg Hansen

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit ...

Price:  $29.12  |  Publisher:  Apress  |  Release:  2020