|
Index Usage for Performance
 Index Structure Details
How
Indexes are Used
The
Clustering Index
Using An Index
to Avoid a Sort
Index
Lookaside
1-Fetch
Index Scan
Use
of Multiple Indexes
Use
of Composite Indexes
Direct Row Access
Program Development
 Testing SQL Statements
Processing Before First Row
Testing for Existence
Commit Frequency
Updating After a Commit
Cursor Repositioning
Optimize for "n" Rows
Cursor with Hold
For Update of and Performance
Connecting to Remote Sites
Error Management
SQL
Communication Area
CHECK Clause
for
Validating Data
Assignment of
Default Values
Using RI for
Validation of Data
Restrict Drop
of Table
Enforcement of
SQL Standards
SQLCODE and
SQLSTATE
SQL Error
Handling
Description of
Error Messages
Data Type
Conversions
|
Batch
Processing
Case Study for Batch Processing
Index
Usage vs. Tablespace Scan
Disallowing
the Use of an Index
Deleting
Many Rows with Reorg
Concurrent
Batch and Online
Restart
Alternatives
Inner & Outer Join Performance
Efficient Joins on Large Tables
Merge,
Nested loop, & Hybrid Join
Outer
Joins - Full, Left, and Right
Apply
Local Predicates Before Join
Influencing
the Join Method
Subselects & Table Expressions
Subselect Compared with a Join
In-Memory
Sparse Index
Transformation
to an IN (list)
Correlated
Subselects
Row Expressions
Update Based on Subselect Results
Table
Expressions and with
Outer
Joins and Local Predicates
Materialization
of Partial Results
Programming for
Performance
Stage
1 and 2 Predicates
Data
Type Effect on Index Usage
Column
& Non-Column Exp.
Arithmetic
and Scalar Functions
CASE
Expressions
FF
for ORed Range Predicates
Range Predicates & Host Variables
LIKE
use of Indexes
Order
of Predicate Evaluation
|
Sorts and List Prefetch
Functions that Require Sorted Rows
Sorts
Can be Avoided
UNION & UNION ALL in Views
Use
of Multiple Indexes
List
Prefetch Thresholds
Pros
and Cons of List Prefetch
Sort
and RID Pool Sizing
Concurrency Control
The Purpose and Need for Locks
Timeouts
and Deadlocks
Cost
and Benefit of Row Locking
Duration
of Locks and Latches
CS/RR/RS/UR by Statement
Acquire/ReleaseTable/Tablespace
Lock
Avoidance
Monitoring Locks and Latches
Locking Trade-Offs
Explain the Access Paths Chosen
Getting Info. on Paths Chosen
How EXPLAIN is
Used
Use of Parameter Markers
CPU Estimate
& Cost Category
Sorts & Sequential Prefetch
Multiple Indexes & List Prefetch
Join Explanations
Subselect Explanations
Locking Explanations
Updates and Deletes
Managing Production Explains
Optimization Hints
|
