Sparse indexing has been around for a number of versions. The history of these on the z/Os side goes back to originally helping with non-correlated subqueries in V4, then star joins in V7, to hashing support of these indexes in V10.
Martin Hubel continues the coverage of new features of DB2 for LUW with an analysis of expression-based indexes -
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.
With DB2’s newly acquired ability to take time zones into account, should we now use timestamps with time zones for our increasing key values?