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)