Product Information
*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 per cent 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!Product Identifiers
PublisherPearson Education (Us)
ISBN-139780130123817
eBay Product ID (ePID)87598155
Product Key Features
Publication Year2001
SubjectComputer Science
Number of Pages656 Pages
LanguageEnglish
Publication NameOracle Sql High-Performance Tuning
TypeTextbook
AuthorGuy Harrison
FormatPaperback
Additional Product Features
Country/Region of ManufactureUnited States
Title_AuthorGuy Harrison