Local cover image
Local cover image

Expert Oracle SQL : optimization, deployment, and statistics / Tony Hasler ; foreword by Tanel Pöder

By: Material type: TextTextSeries: Expert's voice in OraclePublisher: [Berkeley, California] : [Apress], [2014]Description: xxxi, 585 pagesContent type:
  • text
Media type:
  • unmediated
Carrier type:
  • volume
ISBN:
  • 9781430259770
Subject(s): DDC classification:
  • 005.7565
Contents:
Part 1. Basic concepts
SQL features
The cost-base optimizer
Basic execution plan concepts
The runtime engine
Introduction to tuning
Objects statistics and deployment
Part 2. Advanced concepts
Advanced SQL concepts
Advanced execution plan concepts
Object statistics
Part 3. The cost-based optimizer
Access methods
Joins
Final state optimization
Optimizer transformations
Part 4. Optimization
Why do things go wrong?
Physical database design
Rewriting queries
Optimizing sorts
Using hints
Advanced tuning techniques
Part 5. Managing statistics with TSTATS
Managing statistics with TSTATS
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number Status Barcode
Book Book Main Library Reference Section Circulation C 005.7565 H352e 2014 (Browse shelf(Opens below)) Available 125279d
Browsing Main Library shelves, Shelving location: Reference Section, Collection: Circulation Close shelf browser (Hides shelf browser)
C 005.74 El48f 2004 Fundamentals of database systems C 005.74 M284d 2007 Database design, application development, and administration C 005.74 Si582d 2002 Database system concepts C 005.7565 H352e 2014 Expert Oracle SQL : optimization, deployment, and statistics C 005.758 B877o 2001 Oracle9i web development C 005.7585 Au935m 2000 Migrating to Oracle8i C 005.8 C311d 2007 Data communications and network security

Includes index.

Part 1. Basic concepts

SQL features

The cost-base optimizer

Basic execution plan concepts

The runtime engine

Introduction to tuning

Objects statistics and deployment

Part 2. Advanced concepts

Advanced SQL concepts

Advanced execution plan concepts

Object statistics

Part 3. The cost-based optimizer

Access methods

Joins

Final state optimization

Optimizer transformations

Part 4. Optimization

Why do things go wrong?

Physical database design

Rewriting queries

Optimizing sorts

Using hints

Advanced tuning techniques

Part 5. Managing statistics with TSTATS

Managing statistics with TSTATS

There are no comments on this title.

to post a comment.

Click on an image to view it in the image viewer

Local cover image