High Performance Oracle 8 SGL Programming and Tuning Book

"High Performance Oracle8 SQL Programming and Tuning contains everything an Oracle professional needs to know about writing the most efficient SQL statements possible. Unlike other books on Oracle8, this book emphasizes tuning the actual SQL statement, not the Oracle8 database. High Performance Oracle8 SQL Programming and Tuning contains complete coverage of Oracle8, Explain Plan, and SQL Trace/TKPROF. In addition, readers will become experts at tuning SQL statements by trying and studying hundreds of effective (as well as poorly written) queries."

"Demonstrates the timings on a one million row table when using different SQL methods on the same query."
"Explains how to analyze indexes and tables, and to create histograms."
"Shows the reader how to rewrite queries to produce dramatic performance gains."
"Covers Btree indexes, clusters, hash index clusters, and bitmap indexes along with numerous examples and optimization options."

"Most SQL statements so that the reader can use them on their own projects"
Examples of the tuning techniques used in the book
PATROL SQL-Explorer
PATROL Pathfinder
PATROL DB-Voyager

"Pete Cassidy (Dallas, TX) is a Senior Principal Instructor/Consultant at Database Consultants Inc. An instructor at Oracle Corporation for more than five years, he accumulated 74 "perfect teaches" in a two-year period. He was the number one USA Oracle instructor for 92-93. Pete authored the tuning portion of the DBA certification exam at Oracle and has made presentations at IOUW 97, IOUW 90, MOUG, SCOUG, and DOUG. In addition, he is the author of Pete Cassidy's Cookbook for Oracle SQL*Plus,located on the Internet at dci-ltd.com."