This is a comprehensive quide to writing SQL code that's optimized for performance. It includes a unique set of software tools on CD-ROM for benchmarking SQL performance.
"synopsis" may belong to another edition of this title.
(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.
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:
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:
If your Oracle applications must deliver supercharged performance, you can't afford to be without Guy Harrison's Oracle SQL High-Performance Tuning.
"About this title" may belong to another edition of this title.
Shipping:
FREE
Within U.S.A.
Book Description Condition: Good. Pap/Cdr. Used book that is in clean, average condition without any missing pages. Seller Inventory # 289666-75
Book Description Condition: Good. [ No Hassle 30 Day Returns ][ Ships Daily ] [ Underlining/Highlighting: NONE ] [ Writing: NONE ] [ Edition: reprint ] [ 1 CD/Disk(s) Included ] Publisher: Prentice Hall Ptr Pub Date: 1/15/1997 Binding: paperback Pages: 496 reprint edition. Seller Inventory # 6653340
Book Description Condition: Good. Good condition. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Bundled media such as CDs, DVDs, floppy disks or access codes may not be included. Seller Inventory # P10J-02051
Book Description Paperback. Condition: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Seller Inventory # GOR002313258
Book Description paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority!. Seller Inventory # S_389158756
Book Description Paperback. Condition: Very Good. Oracle SQL High-performance Tuning Kit This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 7719-9780136142317
Book Description Paperback. Condition: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 6545-9780136142317
Book Description Condition: Good. SHIPS FROM USA. Used books have different signs of use and do not include supplemental materials such as CDs, Dvds, Access Codes, charts or any other extra material. All used books might have various degrees of writing, highliting and wear and tear and possibly be an ex-library with the usual stickers and stamps. Dust Jackets are not guaranteed and when still present, they will have various degrees of tear and damage. All images are Stock Photos, not of the actual item. book. Seller Inventory # 15-0136142311-G
Book Description Condition: Good. SHIPS FROM USA. Used books have different signs of use and do not include supplemental materials such as CDs, Dvds, Access Codes, charts or any other extra material. All used books might have various degrees of writing, highliting and wear and tear and possibly be an ex-library with the usual stickers and stamps. Dust Jackets are not guaranteed and when still present, they will have various degrees of tear and damage. All images are Stock Photos, not of the actual item. book. Seller Inventory # 6-0136142311-G
Book Description Condition: Sehr gut. Auflage: Pap/Cdr. 491 Seiten ex library book - Altersfreigabe FSK ab 0 Jahre Sprache: Englisch Gewicht in Gramm: 969 23,2 x 17,8 x 3,6 cm, Taschenbuch. Seller Inventory # 344612