Sumário Itens Encontrados: 152Chapter 1 - Parsing in Oracle SQL 1Parsing in SQL by Vadim Tropashko 1Chapter 2 - Are We Parsing Too Much? 10Are We Parsing Too Much? by John Weeg 10What is Identical? 10How Much CPU are We Spending Parsing? 11Library Cache Hits 12Shared Pool Free Space 12Cursors 13Code 15Do What You Can 16Chapter 3 - Oracle SQL Optimizer Plan Stability 17Plan Stability in Oracle 8i/9i by Jonathan Lewis 17The Back Door to the Black Box 17Background / Overview 18Preliminary Setup 19What Does the Application Want to Do? 20What Do You Want the Application to Do? 21From Development to Production 26Oracle 9 Enhancements 27Caveats 28Conclusion 29Chapter 4 - SQL Tuning Using dbms_stats 31Query Tuning Using DBMS_STATS by Dave Ensor 31Introduction 31Test Environment 31Background 32Original Statement 33With Hash Join Hints 33Oracle's Cost-based Optimizer 34CPU Cost 34Key Statistics 36Other Factors 36Cursor Sharing 37Package DBMS_STATS 38Plan Stability 38Getting CBO to the Required Plan 39Localizing the Impact 40Ensuring Outline Use 42Postscript 42Conclusions 43Section Two - SQL Statement TuningChapter 5 - Trees in SQL 44Trees in SQL: Nested Sets and Materialized Path by VadimTropashko 44Adjacency List 44Materialized Path 46Nested Sets 48Nested Intervals 49Partial Order 50The Mapping 52Normalization 54Finding Parent Encoding and Sibling Number 56Calculating Materialized Path and Distance between nodes 57The Final Test 60Chapter 6 - SQL Tuning Improvements 64SQL Tuning Improvements in Oracle 9.2 by VadimTropashko 64Access and Filter Predicates 64V$SQL_PLAN_STATISTICS 69Chapter 7 - Oracle SQL Tuning Tips 73SQL tuning by Don Burleson 73Chapter 8 - Altering SQL Stored Outlines 75Faking Stored Outlines in Oracle 9 by Jonathan Lewis 75Review 75The Changes 76New Features 81Old Methods (1) 82Old Methods (2) 84The Safe Bet 85Conclusion 86References 87Section Three - SQL Index TuningChapter 9 - Using Bitmap Indexes with Oracle 88Understanding Bitmap Indexes by Jonathan Lewis 88Everybody Knows ⦠88What Is a Bitmap Index? 89Do Bitmaps Lock Tables? 91Consequences of Bitmap Locks 92Problems with Bitmaps 94Low Cardinality Columns 95Sizing 102Conclusion 103References 104Chapter 10 - SQL Star Transformations 105Bitmap Indexes 2: Star Transformations by Jonathan Lewis 105The Bitmap Star Transformation 107Warnings 116Conclusion 118References 119Chapter 11 - Bitmap Join Indexes 120Bitmap Indexes 3 â Bitmap Join Indexes by JonathanLewis 120It's fantastic - What's the Problem 122What Is a Bitmap Join Index? 122Issues 128Conclusion 130References 131Section Four - SQL DiagnosticsChapter 12 - Tracing SQL Execution 132Oracle_trace - the Best Built-in Diagnostic Tool? by JonathanLewis 132How Do I ⦠? 132What is oracle_trace 133Uses for oracle_trace 134Putting it All Together 134Some Results 139Now What? 139The Future 141Conclusion 142Caveat 142References 142Chapter 13 - Embedding SQL in Java & PL/SQL 143Java vs. PL/SQL: Where Do I Put the SQL? by DaveMoore 143The Power of a Package 144The Flexibility of Java 146Performance 147Benchmarks 147Environment 148The Tests 148Java: 149PL/SQL: 149Multiple Statements 149PL/SQL: 150Truncate 150Java: 150PL/SQL: 151Benchmark Results 151Single Statement Results 151Multiple Statements Results 152Truncate Results 152Remote Results 152Conclusion 153Chapter 14 - Matrix Transposition in Oracle SQL 155Matrix Transposition in SQL by Vadim Tropashko 155Nesting and Unnesting 156Integer Enumeration for Aggregate Dismembering 157User Defined Aggregate Functions 159Section Five - Advanced SQLChapter 15 - SQL with Keyword Searches 163Keyword Searches by Joe Celko 163Chapter 16 - Using SQL with Web Databases 167Web Databases by Joe Celko 167Chapter 17 - SQL and Calculated Columns 172Calculated Columns by Joe Celko 172Introduction 172Triggers 173INSERT INTO Statement 175UPDATE the Table 176Use a VIEW 176Index 178