High Performance Oracle 8 SQL Programming and Tuning by Pete Cassidy, Paperback | Barnes & Noble
High Performance Oracle 8 SQL Programming and Tuning

High Performance Oracle 8 SQL Programming and Tuning

by Pete Cassidy
     
 
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

Overview

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.

Editorial Reviews

Booknews
A book/CD-ROM package for Oracle developers and database administrators who work with either Oracle8 or Oracle7. Offers many examples of Explain Plans and elapsed times in tables ranging from 14 rows to one million and more rows. The CD-ROM contains demo software and SQL scripts. Annotation c. by Book News, Inc., Portland, Or.

Product Details

ISBN-13:
9781576102138
Publisher:
Coriolis Group
Publication date:
01/26/1997
Edition description:
BK&CD ROM
Pages:
604
Product dimensions:
7.44(w) x 9.29(h) x 1.93(d)

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >