SQL Performance

RPG IV and SQL Developers

It is assumed that participants have at least a basic knowledge of SQL. They should also be familiar with the concept of logical files (DDS described logical file or SQL index).

Database Architecture

• From CQE to SQE

Query Process

• Optimization Process
  • Statistics Manager
  • Access Plan
• Opening Process
  • Open Data Path (ODP)
  • Full Open / Hard Close
• AQP (Adaptive Query Processing)

Access Methods

• Permanent Objects
  • Table Scan / Table Probe
  • Index Scan / Index Probe
• Using temporary Objects

Indexing Strategy

• Access Paths
  • Key Constraints / Binary Radix Indices
  • Encoded Vector Indices (EVI)
• Proactive / Reactive Indexing Strategy

Analysis Feedback Tools

• Index Advisor / Condenser / Evaluator
• Visual Explain
• SQE Plan Cache (Snapshots)
• Database Monitors

Coding Tips

QAQQINI Options