IDUG EMEA

The Query Optimization and Tuning Workshop will be a presentation and discussion covering a variety of optimization and performance tuning topic. It will cover topics like (a) basic optimizer concepts (b) Table Partitioning (c) Row versus Column Oriented Tables (d) Statistics collection (e) Cardinality Estimation (f) Scan Optimization (g) Join optimization (h) Aggregation and Sort optimization (i) Index considerations (k) Materialized Query Tables (l) Replicated Tables (m) Insert, Update, Delete, Merge Performance (n) Resource Configuration considerations (o) Interesting Performance Registry Variables (p) Optimizer Profiles and Guidelines (q) Workload Management (r) Query EXPLAIN (s) Query Writing for Performance (t) Performance Tuning strategies (u) compression (w) clustering data for performance (x) Monitoring and tracing to identify slow queries (y) The future Optimizer with Machine Learning models ... (hmmm almost an a-to-z set of topics :-)