We always assume that tuning, will result in actual monetary savings. Well, with IBMs Measured Workload Pricing this is not always the case. Join well known DB2 speaker Phil Grainger as he explains how IBMs MLC works in practice and what this means to our DB2 world.
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 -
With each new release, DB2 is getting smarter and smarter. However, DB2 is not yet clairvoyant enough to understand the intentions of all queries and turn them into optimal forms. What’s the bottom line? Do you need to worry about how you code? The answer is yes, but not as much as in the past.
There are often multiple ways to code a query, some of which perform better than others. It is not just a matter of effectively utilizing the indexes, but also the SQL constructs. This week, Tony Andrews of Themis, and a popular speaker, author, consultant and trainer is writing on this topic.
Ever hear the saying that the most efficient SQL statement is the one that is never executed? Well, it’s true.