Wrong index references in runstats when using Object Compare on two tables compared at the same time on two databases:
at: Options | Database | DB2 | LUW | Runstats please check:
- Include distribution statistics
- Include Index statistics
- Include Detailed Index statistics
Selecting 2 Tables containing data and doing a right click "Object compare" in the Object Explorer once where both tables are having one additional column.
The result containing the Runstats with the detailed index references contains additional indexes.
WORKAROUND:
None
STATUS:
Waiting for a fix to be released in a future version of Toad for DB2