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