
Résumé
Improve Database Performance by Tuning SQL Statements Tune all types of SQL statements—from a simple SELECT statement to a complex non-correlated subquery—using tips and techniques from SQL expert Don Burleson. Officially authorized by Oracle Corporation, this in-depth resource explains how to take any SQL statement, view the internal execution plan, and change the execution plan 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.
- Understand how SQL tuning fits into the overall Oracle tuning model
- Improve Oracle SQL functionality using extensions such as in-line views and BIFs
- Identify and report on SQL in the library cache
- Tune SQL table access, full-table scans, and parallel query
- Run TKPROF to get a SQL trace report
- Change the execution plans for Oracle SQL statements using Oracle hints
- Use the Oracle8i optimizer plan stability, cost-based optimizer, and rule-based optimizer
- Tune SQL DML statements, SQL subqueries, and data warehouse SQL
- Tune SQL with temporary tables and indexes
- Diagnose and optimize system performance using STATSPACK
Table of Contents
- Background
- 1: Introduction to SQL Tuning
- 2: Overview of the SQL Standard
- 3: Understanding the SQL Execution
- 4: Overview of the SQL Optimizers
- 5: The Interaction between SQL and the Database
- 6: The Interaction between SQL and Tables
- Basic SQL Tuning
- 7: The Steps of Oracle SQL Tuning
- 8: Understanding the Oracle SQL Utilities
- 9: Finding Significant SQL Statements
- 10: Tuning Full-Table Scans
- 11: Optimizing Sorting for Oracle SQL
- 12: Tuning with Oracle Hints
- 13: Tuning with Optimizer Plan Stability
- 14: Tuning with Cost-Based Optimizer
- 15: Tuning with the Rule-Based Optimizer
- 16: Tuning Joins
- Advanced SQL Tuning
- 17: Tuning SQL DML Statements
- 18: Tuning SQL with Temporary Tables
- 19: Tuning Subqueries
- 20: Tuning with Indexes
- 21: Tuning Data Warehouse SQL
- 22: SQL Tuning with STATSPACK
- 23: Tuning SQL with Built-in Function
L'auteur - Donald K. Burleson
Donald K. Burleson is one of the world's top Oracle Database experts with more than 20 years of full-time DBA experience. He specializes in creating database architectures for very large online databases and he has worked with some of the world's most powerful and complex systems.
A former Adjunct Professor, Don Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Mc Graw Hill |
Auteur(s) | Donald K. Burleson |
Parution | 01/09/2001 |
Nb. de pages | 576 |
Format | 18,8 x 23 |
Couverture | Broché |
Poids | 1235g |
Intérieur | Noir et Blanc |
EAN13 | 9780072190588 |
ISBN13 | 978-0-07-219058-8 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse