在这个两部分系列的第一期中,我重点介绍了通过将索引添加到DB 2数据库来减少查询次数的优势和缺点。
In the first installment of this two-part column, I focused on the pros and cons of reducing query times by adding indexes to a DB2 database.
我们使用与 清单 3 中相同的查询来从 DB2 获得信用违约掉期,所以这里不再重复它。
We use the same query as in Listing 3 to obtain credit default swap from DB2, so we won't repeat it here.
我们的例子检索存储在DB 2中的一个XML交易记录的子集,而一个更加一般的、涉及所有信用违约掉期交易的查询,将会返回所有40个交易记录。
Our example retrieves a subset of one XML trade record stored in DB2, while a more general query involving all credit default swap trades would return forty full trade records.
应用推荐