Oracle Sql High-Performance Tuning (Prentice Hall Ptr Oracle Series) - Softcover

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, showing how to achieve performance gains of 100% in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8i SQL and PL/SQL tuning. Harrison begins with a detailed overview of SQL processing in Oracle, and then introduces SQL tuning guidelines that improve virtually any application. Learn how to trace SQL statement execution, create more effective indexes, identify and resolve Oracle Server bottlenecks, and fix poorly performing SQL code. Master Oracle tuning tools such as tkprof and explain; leverage Oracle's parallel query facility for large-volume queries; and maximize the performance of Oracle clusters. The book outlines up-front design techniques for enhancing application efficiency; includes detailed real-world tuning guidelines for both SQL and PL/SQL; and presents opportunities to improve performance by substituting PL/SQL or Java for SQL.

• 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!