Back to Search
ISBN 9780130123817 is out of print and is currently unavailable, alternate formats (if applicable) are shown below.
Available options are listed below:

Oracle SQL High-Performance Tuning (Out of print)

AUTHOR Harrison, Guy
PUBLISHER Prentice Hall (01/08/2001)
PRODUCT TYPE Paperback (Paperback)
Description
*Targets the no.1 Oracle performance bottleneck: SQL and PL/SQL *For all releases through Oracle 8i *Detailed case studies and performance measurements *Large-volume queries, Oracle clusters, Java, parallel query tuning, and much more Your one-stop resource for all Oracle SQL and PL/SQL tuning and optimization Optimizing SQL code is the no.1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition zeroes in on SQL and PL/SQL, demonstrating how to achieve performance gains of 100% or more in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes: *Designing applications to maximize efficiency right from the start *Building indexes that support high-performance queries *Identifying and resolving Oracle Server bottlenecks *Fixing poorly performing SQL code *Identifying opportunities to substitute PL/SQL or Java for SQL *Making the most of Oracles tuning tools, including tkprof and
Show More
Product Format
Product Details
ISBN-13: 9780130123817
ISBN-10: 0130123811
Binding: Paperback or Softback (Trade Paperback (Us))
Content Language: English
Edition Number: 0002
More Product Details
Page Count: 630
Carton Quantity: 12
Product Dimensions: 7.00 x 1.42 x 9.16 inches
Weight: 2.28 pound(s)
Feature Codes: Index, Price on Product, Table of Contents, Illustrated
Country of Origin: US
Subject Information
BISAC Categories
Computers | Database Administration & Management
Computers | Languages - SQL
Dewey Decimal: 005.758
Library of Congress Control Number: 2001272325
Descriptions, Reviews, Etc.
jacket back

  • Targets the #1 Oracle performance bottleneck: SQL and PL/SQL
  • For all releases through Oracle 8i
  • Detailed case studies and performance measurements
  • Large-volume queries, Oracle clusters, Java, parallel query tuning, and much more

Your one-stop resource for all Oracle SQL and PL/SQL tuning and optimization!

Optimizing SQL code is the #1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition zeroes in on SQL and PL/SQL, demonstrating how to achieve performance gains of 100% or more in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes:

  • Designing applications to maximize efficiency right from the start
  • Building indexes that support high-performance queries
  • Identifying and resolving Oracle Server bottlenecks
  • Fixing poorly performing SQL code
  • Identifying opportunities to substitute PL/SQL or Java for SQL
  • Making the most of Oracle's tuning tools, including tkprof and explain
  • Leveraging Oracle's parallel query facility for large-volume queries
  • Maximizing the performance of Oracle clusters

Get all the performance and scalability you're paying for -- without investing in new hardware! Whether you're running OLAP or OLTP applications, Guy Harrison's Oracle SQL High Performance Tuning, Second Edition shows you how, step-by-step!

Show More
publisher marketing
*Targets the no.1 Oracle performance bottleneck: SQL and PL/SQL *For all releases through Oracle 8i *Detailed case studies and performance measurements *Large-volume queries, Oracle clusters, Java, parallel query tuning, and much more Your one-stop resource for all Oracle SQL and PL/SQL tuning and optimization Optimizing SQL code is the no.1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition zeroes in on SQL and PL/SQL, demonstrating how to achieve performance gains of 100% or more in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes: *Designing applications to maximize efficiency right from the start *Building indexes that support high-performance queries *Identifying and resolving Oracle Server bottlenecks *Fixing poorly performing SQL code *Identifying opportunities to substitute PL/SQL or Java for SQL *Making the most of Oracles tuning tools, including tkprof and
Show More
Author: Harrison, Guy
GUY HARRISON has worked with Oracle databases for more than a decade, has conducted many Oracle training seminars, and is author of several books on Oracle, including "Oracle Desk Reference" (Prentice Hall PTR). Currently a product architect at Quest Software, Harrison has conducted many Oracle training seminars and has authored several articles for the "Oracle Technical Journal," He resides in Australia.
Show More
List Price $54.99
Your Price  $54.44
Paperback