db2 advisor and commented "drop index..." entries

[Stephan Arenswald]

Hi All,

I'm using the db2 advisor (db2advis) to get recommendations for my
database. Every time I create recommendations there are a few "drop
index ..." within the output file. But they are always commented, hence
they are not executed.
I searched for a program parameter but found no one. Can anyone explain
why db2advis comments these lines and how i can avoid it?

Regards

[Knut Stolze]

Post by Stephan Arenswald
Hi All,
I'm using the db2 advisor (db2advis) to get recommendations for my
database. Every time I create recommendations there are a few "drop
index ..." within the output file. But they are always commented, hence
they are not executed.
I searched for a program parameter but found no one. Can anyone explain
why db2advis comments these lines and how i can avoid it?

I guess that's because db2advis can't know if the provided workload is
really complete. Maybe you have other statements that really need those
indexes and dropping them would be a bad idea.