Significant Performance Improvements with AI Join Cardinality Estimates in Db2 version 12.1.3

Written by Lori Strain, Tam Minh Tran, and Nicholas Ostan

Db2 version 12.1.3 introduces the capability to allow the optimizer to accurately predict cardinalities of equality joins between tables accounting for correlation between local and join predicates. Tests on the AI Query Optimizer in Db2 12.1.3 have shown significant query performance improvement 

Read More

IDUG Members have access to premium content – better yet, membership is FREE. Click here to create your member profile today. Questions? Contact us!