Module 18: Basic Query optimization

Learn the fundamentals of query performance tuning with Guido Verbraak from IBM Expert Labs. In this session, discover how to identify queries for optimization, interpret access plans, use statistics effectively, and apply practical techniques to improve query efficiency. Tools like Visual Explain, event monitors, and package cache analysis are explored to help you diagnose and resolve performance issues.