Oracle SQL High-Performance Tuning (2nd Edition) |
|
|
|
| Title: | Oracle SQL High-Performance Tuning (2nd Edition) |
| Author: | Guy Harrison |
| Publisher: | Prentice Hall |
| Type: | Book / Paperback |
| Publication Date: | 08 January, 2001 |
| ISBN / ISBN-13: | 0130123811 / 9780130123817 |
| List Price: | $54.99 |
| You Save: | $20.00 |
| Amazon Price: | $34.99 |
|
This book is also available, brand-new, from 3rd-party marketplace sellers at Amazon.com, from $30.00.
|
The HTML code below can be pasted onto your web-site, your MySpace page, or blog - or any number of similar places - to create a link to this page:
If, instead of a text link, you'd like to create a link to this page which will display the book cover, if it's available, then the code below will do exactly that:
Check for the same book at these other US book sites:
• [ Abebooks ]
• [ Alibris ]
• [ Barnes & Noble ]
• [ Half.com ]
• [ Powells ]
… or check UK bookstores
|
Editorial Review / Publisher's Information:
Product Description
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.
|
