Résumé
- 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 youhow, step-by-step!
Contents- Part I: Introduction to SQL Tuning
- 1: Introduction to SQL Tuning
- 2: SQL Tuning Quick Start
- 3: Review of SQL
- Part II: SQL Tuning Theory
- 4: SQL Processing Internals
- 5: The Optimizer
- 6: Indexing and Clustering
- 7: Tracing and Explaining SQL
- Part III: SQL Tuning in Practice
- 8: Tuning Table Access
- 9: Tuning Joins and Subqueries
- 10: Sorts, Aggregates and SET Operations
- 11: Parallel SQL
- 12: Optimizing DML
- 13: VLDB and Warehousing
- 14: Using and Tuning PL?SQL
- 15: Using and Tuning Oracle Java
- 16: Oracle Object Types
- 17: Miscellaneous Topics
- Part IV: Beyond SQL Tuning
- 18: Application Design Issues
- 19: Oracle Server Design
- 20: Oracle Server Tuning
- Appendix A: Reference
- Appendix B: Glossary
- Appendix C: Configuring Development Tools
- Appendix D: Oracle Server Configuration
- Appendix E: Bibliography and Resources
- Index
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Prentice Hall |
| Auteur(s) | Benett Harrison |
| Parution | 01/12/2000 |
| Édition | 2eme édition |
| Nb. de pages | 630 |
| Format | 17,8 x 23,4 |
| Couverture | Broché |
| Poids | 1250g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780130123817 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
