hi,

our db2advis is broken and i am trying to find other ways to get
recommended indexes
i tried using command "SET CURRENT EXPLAIN MODE RECOMMEND INDEXES" and
it populated ADVISE_INDEXES table. new indexes recommended by this
command does not have runstats on it.
how can i evaluate new suggested indexes ?
do i have to physically create these indexes and then explain my SQL ?
can i do it without actually creating suggested indexes ?
what is the difference between "SET CURRENT EXPLAIN MODE RECOMMEND
INDEXES"
and "SET CURRENT EXPLAIN MODE EVAULATE INDEXES"
they both seems to fill same kind of information in ADVISE_INDEXES
table.
please suggest me a way to get around functionality of db2advis

regards,
jag