Skip Navigation Links

Descision Support Browser

InnovizeIT for DB2 includes a powerful descision support browser which aids in understanding the change recommendations, and analyzing their implications. Figure 1 illustrates a decision workspace which shows a pair of indices, one of which (Index1) is contained in the other (Index2). Figure 2 shows drilling down to investigate which programs make use of one of those indices, what access paths are used and the actual SQL utilizing the index. This information ensures that removing one of the indices can be performed with the lowest possible risk.

Figure 1: Contained Indices ( click to expand)

Figure 2: Drill down to program and access level ( click to expand)