I am seeing something in DB2 that I've never seen before. DB2_VERSION: 09.05.5 AIX VERSION: 18.104.22.168 I've got a query that is properly indexed. In fact, it’s heavily indexed. However, when I get the ...
The Following is the TCB index that I could get using a command for my DB2 database. I don't know how to analyze it. Which columns are important? What do they mean? TCB Index Stats: Address ...
I'm trying to evaluate different approaches to analyzing the benefit of changing the set of indexes that are available. If I pick some representative queries from my workload, I can run EXPLAIN and ...