Oracle SQL High-Performance Tuning - Couverture souple

Harrison, Guy

Couverture souple

ISBN 10 : 0136142311 ISBN 13 : 9780136142317

Editeur : Prentice Hall, 1997

Synopsis

61423-0 The complete developer's guide to optimizing Oracle SQL code. Optimizing SQL code is the #1 factor in improving Oracle database performance. Yet most guides to Oracle tuning virtually ignore SQL. Until now. Oracle SQL High-Performance Tuning zeroes in on SQL, showing how to achieve performance gains of 100% or more in many applications. Expert Oracle developer Guy Harrison presents a detailed overview of SQL processing, and then introduces SQL tuning guidelines that improve virtually any application. Learn how to: *Choose execution plans. *Work with joins. *Search for nulls and ranges. *Trace SQL statement execution. *Build indexes that support efficient queries. *Optimize virtually all type of SQL including: views, hierarchical queries, table scans, GROUP BY, updates, subqueries, distributed SQL, and more. As databases grow, and ad hoc queries to data warehouses increase, optimizing SQL becomes even more critical. Harrison offers practical guidance on using Oracle's parallel query facility for large-volume queries, and shows when to use Oracle's PL/SQL instead of standard SQL.The book is replete with examples, showing poorly tuned SQL, how to fix it-and specific performance measurements collected on a wide range of computer hardware, from high-end UNIX SMP hosts to 486 laptops running Personal Oracle. The CD-ROM contains an extraordinary collection of Oracle SQL tuning tools, including: *A complete freeware Tuning Toolkit for generating SQL execution plans in a Windows environment, and for monitoring server load and efficiency. *Trial versions of the SQLab tuning environment, Precise/SQL tuning tools, and SQL Navigator development environment. *Full-function 90-day trial versions of Personal Oracle for Windows 3.1 and Windows 95. If your Oracle applications must deliver supercharged performance, you can't afford to be without Guy Harrison's Oracle SQL High-Performance Tuning.

A propos du livre

Quatrième de couverture

61423-0

The complete developer's guide to optimizing Oracle SQL code.

Optimizing SQL code is the #1 factor in improving Oracle database performance. Yet most guides to Oracle tuning virtually ignore SQL. Until now. Oracle SQL High-Performance Tuning zeroes in on SQL, showing how to achieve performance gains of 100% or more in many applications.

Expert Oracle developer Guy Harrison presents a detailed overview of SQL processing, and then introduces SQL tuning guidelines that improve virtually any application. Learn how to:

• Choose execution plans.
• Work with joins.
• Search for nulls and ranges.
• Trace SQL statement execution.
• Build indexes that support efficient queries.
• Optimize virtually all type of SQL including: views, hierarchical queries, table scans, GROUP BY, updates, subqueries, distributed SQL, and more.

As databases grow, and ad hoc queries to data warehouses increase, optimizing SQL becomes even more critical. Harrison offers practical guidance on using Oracle's parallel query facility for large-volume queries, and shows when to use Oracle's PL/SQL instead of standard SQL.

The book is replete with examples, showing poorly tuned SQL, how to fix it—and specific performance measurements collected on a wide range of computer hardware, from high-end UNIX SMP hosts to 486 laptops running Personal Oracle.

The CD-ROM contains an extraordinary collection of Oracle SQL tuning tools, including:

• A complete freeware Tuning Toolkit for generating SQL execution plans in a Windows environment, and for monitoring server load and efficiency.
• Trial versions of the SQLab tuning environment, Precise/SQL tuning tools, and SQL Navigator development environment.
• Full-function 90-day trial versions of Personal Oracle for Windows 3.1 and Windows 95.

If your Oracle applications must deliver supercharged performance, you can't afford to be without Guy Harrison's Oracle SQL High-Performance Tuning.

Biographie de l'auteur

GUY HARRISON has worked with Oracle databases for more than a decade, has conducted many Oracle training seminars, and is author of several books on Oracle, including Oracle Desk Reference (Prentice Hall PTR). Currently a product architect at Quest Software, Harrison has conducted many Oracle training seminars and has authored several articles for the Oracle Technical Journal. He resides in Australia.

Détails de l'édition

• Éditeur: Prentice Hall
• Date d'édition: 1997
• ISBN 10: 0136142311
• ISBN 13: 9780136142317
• Reliure: Broché
• Langue: anglais
• Nombre de pages: 512
• Coordonnées du fabricant: non disponible