How does Db2 z transform your SQL query for better performance

---

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

There is currently no attachment for How does Db2 z transform your SQL query for better performance

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

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!