Oracle Sql High Performance Tuning (Prentice Hall PTR Oracle)

 
9780130123817: Oracle Sql High Performance Tuning (Prentice Hall PTR Oracle)

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.

"synopsis" may belong to another edition of this title.

From the Publisher:

Table of contents
CONTENTS:

(NOTE: Each chapter begins with an Introduction and concludes with a Chapter Summary.)

Introduction

I. THE THEORY OF SQL TUNING.

1. Introduction to SQL Tuning.

Why Tune SQL? The SQL Tuning Process.

2. Review of SQL.

History of SQL. Types of SQL Statements. Query Operations. Views. NULLs and Three-valued Logic. Transactions. Oracle Extensions to the ANSI Standard. Some Comments on the SQL Non-Procedural Approach.

3. SQL Processing.

Overview of SQL Processing. Parsing. Executing SQL. Query Optimization.

4. Principles of Indexing and Clustering.

The B*-Tree Index. Index Clusters. Hash Clusters. Bitmapped Indexes. Index Only Tables.

5. Tracing Oracle SQL.

EXPLAIN PLAN. Using SQL Trace. Using the AUTOTRACE Facility in SQL*PLUS.

II. PRACTICAL SQL TUNING

6. Tuning Table Access.

Full Table Scans and Index Lookups. Alternatives to Full Table Scans. Optimizing Index Lookups. Optimizing Table Scans. Using Hints to Influence an Access Path.

7. Optimizing Joins and Subqueries.

Choosing the Best Join Method. Choosing the Best Join Order. Optimizing Joins with Index Clusters. Outer Joins. Star Joins. Hierarchical Queries. Simple Subqueries. Subqueries Involving the IN Operator. Correlated Subqueries.

8. Optimizing Sorting and Grouping.

Sort Operations. Aggregate Operations. Set Operations. Intersect. Minus.

9. Optimizing Data Manipulation Statements.

Optimizing Individual DML Statements. Optimizing Transactions. Other DML Performance Issues. Locking.

10. Using and Tuning PL/SQL.

Performance Characteristics of PL/SQL. USING PL/SQL in Place of "Standard" SQL. Optimizing PL/SQL.

11. Miscellaneous Topics.

Optimizing Views. Using Snapshots. Distributed SQL. Sequences. Using Decode. Data Definition Language.

12. Parallel SQL.

Understanding Parallel SQL. Parallel Query Option. Examples of Parallel Queries. Parallel DDL and DML.

13. SQL Tuning Case Studies.

Case Study 1: Using Concatenated Indexes. Case Study 2: The Rule Based Optimizer, Index Merges and Bind Variables. Case Study 3: The Slowly Degrading Query. Case Study 4: A Number Range Lookup. Case Study 5: The First Rows Approach.

III. BEYOND SQL TUNING.

14. Data Model and Application Design.

Building Tuning into the Design Process. Designing an Efficient Physical Data Model. Application Design.

15. Building A High-Performance Oracle Database Server.

A Review of the Oracle Architecture. Sizing the Host Computer. Building the Oracle Database.

16. Tuning the Database Server.

Evaluating Operating System Performance. Recognizing Oracle Database Bottlenecks.

Appendix A : Reference. Appendix B: Glossary. Appendix C: Configuring Development Tools. Appendix D: Oracle Server Configuration. Appendix E: Differences Between Oracle Versions. Appendix F: Bibliography and Resources. Appendix G: Contents of the CD-ROM. Index.

From the Back Cover:

  • 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!

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Harrison, Guy
Published by Prentice Hall
ISBN 10: 0130123811 ISBN 13: 9780130123817
New Quantity Available: > 20
Seller
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 0130123811

More Information About This Seller | Ask Bookseller a Question

Buy New
28.25
Convert Currency

Add to Basket

Shipping: 2.80
Within U.S.A.
Destination, Rates & Speeds

2.

Harrison, Guy
Published by Prentice Hall (2001)
ISBN 10: 0130123811 ISBN 13: 9780130123817
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2001. Paperback. Book Condition: New. 2. Bookseller Inventory # DADAX0130123811

More Information About This Seller | Ask Bookseller a Question

Buy New
42.01
Convert Currency

Add to Basket

Shipping: 3.19
Within U.S.A.
Destination, Rates & Speeds

3.

Harrison, Guy
Published by Prentice Hall (2001)
ISBN 10: 0130123811 ISBN 13: 9780130123817
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2001. Paperback. Book Condition: New. book. Bookseller Inventory # 0130123811

More Information About This Seller | Ask Bookseller a Question

Buy New
46.81
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Harrison, Guy
Published by Prentice Hall (2001)
ISBN 10: 0130123811 ISBN 13: 9780130123817
New Softcover Quantity Available: > 20
Seller
Palexbooks
(Sanford, NC, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2001. Book Condition: New. Brand new! Please provide a physical shipping address. Bookseller Inventory # 9780130123817

More Information About This Seller | Ask Bookseller a Question

Buy New
50.42
Convert Currency

Add to Basket

Shipping: 2.40
Within U.S.A.
Destination, Rates & Speeds

5.

Harrison, Guy
Published by Prentice Hall (2001)
ISBN 10: 0130123811 ISBN 13: 9780130123817
New Softcover Quantity Available: 1
Seller
Book Deals
(Lewiston, NY, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2001. Book Condition: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: 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!. Bookseller Inventory # ABE_book_new_0130123811

More Information About This Seller | Ask Bookseller a Question

Buy New
52.87
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

6.

Harrison, Guy
Published by Prentice Hall (2001)
ISBN 10: 0130123811 ISBN 13: 9780130123817
New Paperback Quantity Available: 3
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2001. Paperback. Book Condition: New. Bookseller Inventory # P110130123811

More Information About This Seller | Ask Bookseller a Question

Buy New
59.57
Convert Currency

Add to Basket

Shipping: 2.39
Within U.S.A.
Destination, Rates & Speeds

7.

Harrison, Guy
Published by Prentice Hall PTR (2000)
ISBN 10: 0130123811 ISBN 13: 9780130123817
New Paperback Quantity Available: 1
Seller
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description Prentice Hall PTR, 2000. Paperback. Book Condition: Brand New. 2nd sub edition. 630 pages. 9.00x6.75x1.75 inches. In Stock. Bookseller Inventory # zk0130123811

More Information About This Seller | Ask Bookseller a Question

Buy New
60.16
Convert Currency

Add to Basket

Shipping: 6
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Harrison, Guy
ISBN 10: 0130123811 ISBN 13: 9780130123817
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97801301238171.0

More Information About This Seller | Ask Bookseller a Question

Buy New
74.87
Convert Currency

Add to Basket

Shipping: 3.19
Within U.S.A.
Destination, Rates & Speeds