Oracle SQL High-Performance Tuning

by Guy Harrison

A guide to using Oracle's parallel query facility for large volume queries focusing on SQL and PL/SQL. Harrison, an Oracle developer and consultant, overviews SQL processing and introduces guidelines to improve applications, including execution plans, work with joins, nulls and ranges search, index building, hierarchical queries, table scans, GROUP BY, updates, and distributed SQL. The accompanying CD-ROM features a set of tools for detecting and correcting SQL bottlenecks. Annotation c. by Book News, Inc., Portland, Or.

491 pages, Paperback

First published January 1, 1997

About the author

There is more than one author with this name

Reviews

[John · Rating 5 out of 5]

The best book about SQL tuning that I've seen and a must have book for Oracle DBAs & SQL Developers. A mentor recommended this book to me over a decade ago on my first DBA Consulting Assignment and I have used & referred back to it since then.