Oracle SQL High-Performance Tuning
- Paperback | 656 pages
- 175.26 x 231.14 x 38.1mm | 1,065.94g
- 08 Jan 2001
- Pearson Education (US)
- Prentice Hall
- Upper Saddle River, United States
- 2nd edition
- w. figs.
Other books in this series
28 Dec 2002
Back cover copy
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!
Table of contents
About Guy Harrison