Oracle High-Performance SQL Tuning
Improve Database Performance by Tuning SQL StatementsTune 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 modelImprove Oracle SQL functionality using extensions such as in-line views and BIFsIdentify and report on SQL in the library cacheTune SQL table access, full-table scans, and parallel queryRun TKPROF to get a SQL trace reportChange the execution plans for Oracle SQL statements using Oracle hintsUse the Oracle8ioptimizer plan stability, cost-based optimizer, and rule-based optimizerTune SQL DML statements, SQL subqueries, and data warehouse SQLTune SQL with temporary tables and indexesDiagnose and optimize system performance using STATSPACK