How does Db2 z transform your SQL query for better performance

(2AO)

Stream: Virtual Room 2
Time: 12:00 - 13:00

Presentation

This presentation will discuss the transformation Db2 Z does for customer's SQL queries to optimize the CPU usage and query elapse time. The presentation will cover the optimization techniques Db2 conduct for

Predicate Pruning for UNION/UNION ALL, Table Expressions, and Views
UNION Distribution
View/ table expression merged vs. materialization
. Predicate Push Down, Predicate Transformation, Predicate Transitive Closure
and many other optimization techniques

Attachments

2AO Attachments

Speakers

Huong Tran at IBM USA

Lead developer of Db2 Z Query Semantic Transformation at IBM

Email: tranht@us.ibm.com

Huong Tran at IBM USA

Lead developer of Db2 Z Query Semantic Transformation at IBM

Email: tranht@us.ibm.com

Huong Tran at IBM USA

Lead developer of Db2 Z Query Semantic Transformation at IBM

Email: tranht@us.ibm.com

Huong Tran at IBM USA

Lead developer of Db2 Z Query Semantic Transformation at IBM

Email: tranht@us.ibm.com

Huong Tran at IBM USA

Lead developer of Db2 Z Query Semantic Transformation at IBM

Email: tranht@us.ibm.com

Huong Tran at IBM USA

Lead developer of Db2 Z Query Semantic Transformation at IBM

Email: tranht@us.ibm.com

Huong Tran at IBM USA

Lead developer of Db2 Z Query Semantic Transformation at IBM

Email: tranht@us.ibm.com

Feedback

Click here to give some Feedback so we can make it even better next year!