Understanding Query Transformation’s Role in Time Travel Queries (by By Daniel L Luksetich)

Continuing this month's theme of Temporal Data (Time Travel Query), IDUG Content Committee chair Dan Luksetich goes behind the scenes to look at how DB2 processes temporal queries.  Check out his article here -

http://www.idug.org/p/do/sd/sid=6481&type=0

The key message is that while temporal SQL constructs makes writing complex time series queries easier, you really need to understand and consider the performance implications, especially when it comes to queries which need to access both the base and history tables of a system temporal implementation. As someone said to me recently "magic doesn't just happen".  It doesn't mean you shouldn't use these constructs.  You just need to allow for the processing involved and tune accordingly.  In some performance critical situations it may be better to code standard SQL statements for optimum performance.  

Once again Dan offers us real insights into DB2 performance.

 

Recent Stories
Lessons Learned of Locking and Latches by Adrian Burke

Db2 for z/OS locking basics

A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas