Local cover image

Normal view MARC view ISBD view

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

By:

Hasler, Tony [author]

Material type: Text

TextSeries: 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.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Status	Barcode
Book	Main Library Reference Section	Circulation	C 005.7565 H352e 2014 (Browse shelf(Opens below))	Available	125279d

Includes index.