IDUG EMEA has ended
Back To Schedule
Saturday, October 22 • 09:00 - 17:00
WS2 | Query Optimization and Performance Workshop | Presented by IBM

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

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 :-)

avatar for Calisto Zuzarte

Calisto Zuzarte

Senior Technical Staff Member, IBM
Calisto Zuzarte, IBM, is Senior Technical Staff Member (STSM) and a Master Inventor with several patents and publications to his credit.  His focus area is Query Optimization particularly with analytic workloads. He represents IBM on the ANSI and ISO SQL Standards Committee.

Saturday October 22, 2022 09:00 - 17:00 BST
1 | Carrick