Oracle High-Performance SQL Tuning
- 7h 34m
- Donald K. Burleson
- Oracle Press
- 2001
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 Oracle 8i 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
About the Author
Donald Keith Burleson is one of the world's top Oracle Database experts with more than 20 years of full-time 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 leading Database author, Don has written 12 books, published more than 60 articles in national magazines, and serves as Editor-in-Chief of Oracle Internals, a leading Oracle Database journal. His books include:
- Oracle Internals: Tips, Tricks, and Techniques for DBAs (CRC Press, 2001)
- Oracle High-Performance SQL Tuning (Osborne/McGraw-Hill, Oracle Press, 2001)
- Unix for the Oracle DBA (O'Reilly & Associates, 2000)
- Oracle SAP Administration (O'Reilly & Associates, 1999)
- Inside the Database Object Model (CRC Press, 1998)
- High Performance Oracle Data Warehousing (Coriolis Publishing, 1997)
- High Performance Oracle 8 Tuning (Coriolis Publishing, 1997)
- High Performance Oracle Database Applications (Coriolis Publishing, 1996)
- Oracle Databases on the Web (Coriolis Publishing, 1996)
- Managing Distributed Databases (John Wiley & Sons, 1994)
- Practical Application of Object-Oriented Techniques to Relational Databases (John Wiley & Sons, 1993)
Donald Burleson also provides remote DBA support and consulting services, specializing in Oracle database tuning, Oracle data warehousing, and design of Oracle graduate-level computer courses. He is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.
In this Book
-
Introduction to SQL
-
Overview of Oracle SQL Extensions
-
Understanding SQL Execution
-
Overview of the SQL Optimizers
-
SQL Internal Processing
-
Tuning SQL Table Access
-
The Steps to Oracle SQL Tuning
-
Understanding Oracle SQL Utilities
-
Locating Significant SQL Statements
-
Tuning Full-Table Scans and Parallel Query
-
Optimizing Sorting for Oracle SQL Statements
-
Tuning with Oracle Hints
-
Tuning with Optimizer Plan Stability
-
Tuning with the Cost-Based Optimizer
-
Tuning with the Rule-Based Optimizer
-
Tuning Table Joins
-
Tuning SQL DML Statements
-
Tuning SQL with Temporary Tables
-
Tuning SQL Subqueries
-
Tuning SQL with Indexes
-
Tuning Data Warehouse SQL
-
SQL Tuning with STATSPACK
-
Tuning SQL with Built-in Functions and Special Operators
