Oracle SQL High-Performance Tuning
Guy HarrisonBooks.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.
Overview
- 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!
This SQL code optimization guide overviews SQL, focusing on the theory and practice of SQL processes, tuning and optimization. Discusses principles of indexing and clustering, and shows you how to use tools to trace SQL processes. It guides you through practical tuning and optimization of table access, joins, subqueries, sorting, grouping, and data manipulation statements. Analyzing pros/cons of SQL substitution with PL/SQL and the use of parallel SQL, the book presents tuning case studies. Good data model and application design are emphasized. CD-ROM contains trial product versions, freeware tuning toolkit and monitoring utility. Users must be familiar with SQL and ORACLE RDBMS.
Synopsis
- 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!
Booknews
A guide for Oracle developers and database administrators, covering 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, building indexes, identifying and resolving Oracle Server bottlenecks, fixing poorly performed SQL code, and leveraging Oracle's parallel query facility. Harrison is author of several books on Oracle. Annotation c. Book News, Inc., Portland, OR (booknews.com)