Oracle High-Performance SQL Tuning

Dekorationsartikel gehören nicht zum Leistungsumfang.

Sprache: Englisch

71,45 €

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 1-2 Wochen

Kategorien:

Beschreibung

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 den Autor

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 (O'Reilly), 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

Details

Erscheinungsjahr:	2001
Fachbereich:	Anwendungs-Software
Genre:	Importe , Informatik
Rubrik:	Naturwissenschaften & Technik
Medium:	Taschenbuch
Inhalt:	Kartoniert / Broschiert
ISBN-13:	9780072190588
ISBN-10:	0072190582
UPC:	783254037007
EAN:	0783254037007
Sprache:	Englisch
Einband:	Kartoniert / Broschiert
Autor:	Burleson, Donald Burleson Donald
Hersteller:	McGraw-Hill
Verantwortliche Person für die EU:	Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de
Maße:	235 x 191 x 32 mm
Von/Mit:	Donald Burleson (u. a.)
Erscheinungsdatum:	15.08.2001
Gewicht:	1,115 kg