Oracle high-performance SQL tuning

Donald K. Burleson

Osborne/McGraw-Hill, Jul 27, 2001 - Computers - 575 pages

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.

Contents

• Background: 1
• Introduction to SQL: 3
• The Beginnings of SQL: 6

About the author

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.

Bibliographic information

• Title: Oracle high-performance SQL tuning; Oracle Press Series
• Author: Donald K. Burleson
• Edition: illustrated
• Publisher: Osborne/McGraw-Hill, 2001
• ISBN: 0072190582, 9780072190588
• Length: 575 pages
• Subjects: Computers / Certification Guides / General; Computers / Database Management / General; Computers / Desktop Applications / Databases; Computers / General; Computers / Programming Languages / SQL; Database management; Oracle (Computer file); Relational databases; SQL (Computer program language)