In this comprehensive overview of DB2 10, for z/OS Lori Ann Galluzzo goes through the features of DB2 10 in great detail. Each feature is discussed, along with how and when to take advantage of the feature, as well as some pitfalls and things to watch out for.
We use Explain to find out the access path for a query. Jim Dee, from BMC shows you how you can compare the access path with previous versions of the query or package – comparing the estimated costs, and identifying those that have changed with a rebind.
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.
The end of indexing month at IDUG.org doesn′t need to be the end of your quest for smaller, faster, and fewer indexes. For your convenience, here are the indexing articles that were featured this month
My wife and I set a goal early in our married life. It was to pay for our daughters’ university education (at a school of their choosing) so they could start their adult lives debt free. We were able to keep that promise, in part due to the opportunity to tune DB2.