Name: Oracle High-Performance SQL Tuning von Donald Burleson
SKU: 9780072190588
Price: 12.99 EUR
Availability: InStock

Oracle High-Performance SQL Tuning Zusammenfassung

Oracle High-Performance SQL Tuning Donald Burleson

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution

This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

Über Donald Burleson

Don Burleson (Kittrell, NC) has 20 years of experience as a database administrator and has written 9 books on database management including Oracle SAP Administration (OReilly), High-Performance Oracle8 Tuning, High-Performance Oracle Data Warehousing, High-Performance Oracle Database Applications (Coriolis) and Oracle8 Tuning, German Edition (Sybex). Don has taught more than 100 University courses and regularly conducts in-house Oracle training.

Inhaltsverzeichnis

PART I Background 1 Introduction to SQL 2 Overview of Oracle SQL Extensions 3 Understanding SQL Execution 4 Overview of the SQL Optimizers 5 SQL Internal Processing 6 Tuning SQL Table Access PART II Basic SQL Tuning 7 The Steps to Oracle SQL Tuning 8 Understanding Oracle SQL Utilities 9 Locating Significant SQL Statements 10 Tuning Full-Table Scans and Parallel Query 11 Optimizing Sorting for Oracle SQL Statements 12 Tuning with Oracle Hints 13 Tuning with Optimizer Plan Stability 14 Tuning with the Cost-Based Optimizer 15 Tuning with the Rule-Based Optimizer 16 Tuning Table Joins PART III Advanced SQL Tuning 17 Tuning SQL DML Statements 18 Tuning SQL with Temporary Tables 19 Tuning SQL Subqueries 20 Tuning SQL with Indexes 21 Tuning Data Warehouse SQL 22 SQL Tuning with STATSPACK 23 Tuning SQL with Built-in Functions and Special OperatorsIndex PART I Background 1 Introduction to SQL 2 Overview of Oracle SQL Extensions 3 Understanding SQL Execution 4 Overview of the SQL Optimizers 5 SQL Internal Processing 6 Tuning SQL Table Access PART II Basic SQL Tuning 7 The Steps to Oracle SQL Tuning 8 Understanding Oracle SQL Utilities 9 Locating Significant SQL Statements 10 Tuning Full-Table Scans and Parallel Query 11 Optimizing Sorting for Oracle SQL Statements <$TSpAbove=165;>12 Tuning with Oracle Hints 13 Tuning with Optimizer Plan Stability 14 Tuning with the Cost-Based Optimizer 15 Tuning with the Rule-Based Optimizer 16 Tuning Table Joins PART III Advanced SQL Tuning 17 Tuning SQL DML Statements 18 Tuning SQL with Temporary Tables 19 Tuning SQL Subqueries 20 Tuning SQL with Indexes 21 Tuning Data Warehouse SQL 22 SQL Tuning with STATSPACK 23 Tuning SQL with Built-in Functions and Special Operators

Zusätzliche Informationen

Sku

GOR005313579

ISBN 13

9780072190588

ISBN 10

0072190582

Titel

Oracle High-Performance SQL Tuning Donald Burleson

Autor

Donald Burleson

Zustand

Gebraucht - Sehr Gut

Bindung

Broschiert

Verlag

McGraw-Hill Education - Europe

Datum

2001-08-16

Anzahl der Seiten

656

Preise

N/A

Begleitschreiben

Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.

Hinweis

Dies ist ein gebrauchtes Buch. Es wurde schon einmal gelesen und weist von der früheren Nutzung Gebrauchsspuren auf. Wir gehen davon aus, dass es im Großen und Ganzen in einem sehr guten Zustand ist. Sollten Sie jedoch nicht vollständig zufrieden sein, setzen Sie sich bitte mit uns in Verbindung.