|
Concepts and Facilities
 DB2 Usage Architecture
The SQL Language
Unit of Work (UOW)
SQLCODE and
SQLSTATE
Binding SQL into Package
or Plan
The Optimizer
DB2 Objects
The Clustering
Index
Authorization Ids
Security and
Authorization
The Catalog Tables
DB2I and QMF
Using SQL
The SQL Language
SELECT Statement
String Searches
Column Functions
Selecting Data by
Groups
Data Type
Conversion
String Manipulation
Functions
Date/Time
Extraction & Calc.
Date Calculations
Using
Labeled Durations
Day of the Week
Further Use of SQL
Subselect
Correlated
Subselect
Update Based on Subselect
Joining Tables
Join Involving
Nulls
Outer Join
Union,
Intersection, & Difference
Organization/BOM
Processing
Insert/Update/Delete
Referential
Integrity and Updates
|
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
Scrollable Cursors
Optimize for n Rows
Fetch
First n Rows
Cursor with Hold
For Update of and Performance
Identity Column
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
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 with 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
|
|
|
|
|
