Cost-Based Oracle Fundamentals (Expert's Voice in Oracle) - Image 1

£32.22

Apress Cost-Based Oracle Fundamentals (Expert's Voice in Oracle)

Name: Cost-Based Oracle Fundamentals (Expert's Voice in Oracle)
Brand: Apress
Price: 32.47 GBP
Availability: InStock

Applications

Price History & Forecast

Last 53 days • 53 data points (No recent data available)

Historical

Generating forecast...

Price Distribution

Price distribution over 53 days • 3 price levels

Days at Price

Current Price

Price Analysis

Most common price: £32 (34 days, 64.2%)

Price range: £32 - £32

Price levels: 3 different prices over 53 days

Description

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.

Product Specifications

Brand: Apress
Format: paperback
ASIN: 1590596366
Category: Books > Subjects > Computing & Internet > Databases > Applications
Domain: Amazon UK
Release Date: 02 November 2005
Listed Since: 10 December 2006

Barcode

No barcode data available

Apress Cost-Based Oracle Fundamentals (Expert's Voice in Oracle)

Price History & Forecast

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

Oracle Core: Essential Internals for DBAs and Developers (Expert's Voice in Databases)

Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

Relational Database Index Design and the Optimizers: DB2, Oracle, SQL Server, et al.

Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

Database Systems: A Pragmatic Approach

Pro Oracle SQL (Expert's Voice in Oracle)

Expert Oracle Database Architecture: Techniques and Solutions for High Performance and Productivity

Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

Troubleshooting Oracle Performance

Database Performance at Scale: A Practical Guide

Expert PL/SQL Practices: for Oracle Developers and DBAs

Physical Database Design Using Oracle: 1 (Foundations of Database Design)

Oracle PL/SQL Performance Tuning Tips & Techniques (DATABASE & ERP - OMG)

Extending Oracle Application Express with Oracle Cloud Features: A Guide to Enhancing APEX Web Applications with Cloud-Native and Machine Learning Technologies

Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

Conceptual Data Modeling and Database Design: A Fully Algorithmic Approach, Volume 1: The Shortest Advisable Path

Expert Oracle Database Architecture

Oracle Internals: Tips, Tricks, and Techniques for DBAs

Oracle Database 11g Dba Handbook (Oracle Press)

Oracle PL/SQL by Example (The Oracle Press Database and Data Science)

Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database

Automated Physical Database Design and Tuning: Emerging Directions in Database Systems and Applications

The Method R Guide to Mastering Oracle Trace Data

Getting Started with Oracle Cloud Free Tier: Create Modern Web Applications Using Always Free Resources