This webinar presents IBM Db2's latest advancement in AI-powered
query optimization, introducing AI powered join cardinality estimation,
new in version 12.1.3. Building upon the Single Table Cardinality Model
released in Db2 12.1, this enhancement addresses critical limitations in
traditional join cardinality estimation by leveraging machine learning to
understand complex relationships between local and join predicates
across tables.
Key features and benefits include:
- Reliable performance: some queries execute up to 10 times
faster
- Minimal Resource Consumption: reuse of existing models so that
no new models required
- Automation: reduces query tuning and eliminates the need for
statistical views
In this webinar we will discuss in detail:
- The importance and challenges of cardinality estimation
- How Db2 uses neural networks to improve join cardinality
estimation
- Our internal performance test results on TPC-DS and SAP BW
workloads
- How better cardinality estimates, result in improved access plans
and superior performance without any tuning required.