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.
We hope that you’ve enjoyed this month’s articles on DB2 performance on z/OS. We talked about the new performance possibilities in DB2 11, about performance hints and tips for framework development, about explaining tuning to C-level and about efficient ways of replication.