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.
Calisto Zuzarte from IBM explains the ins and outs of writing SQL for performance
Today data exists everywhere. You can find it in databases and big data clusters, in branch offices or manufacturing devices, in ATMs, in cars, trucks, and in sensors. The typical enterprise may have hundreds of different data sources containing the valuable data you need.
This article is dedicated to SQL/XML functions. The article is built around simple examples to illustrate how those functions can be used in certain scenarios.
Discovered in my dusty email archives, information for an undocumented feature from 2009 to provide a server-side mechanism to manipulate the default isolation level for connections issuing dynamic SQL...