Jorge,
Since you know about the generate index I will not give you all the step (tell me if you required them).
About the "generate index" YES it's working to recreate the indexes.
look at this text from my log when I use the option on F0101.
===================================================================
DROP INDEX F0101_1 ON F0101
CREATE UNIQUE INDEX F0101_1 ON F0101 (ABAN8 ASC)
CREATE INDEX F0101_2 ON F0101 (ABDC ASC)
CREATE INDEX F0101_3 ON F0101 (ABALKY ASC)
CREATE INDEX F0101_4 ON F0101 (ABTAX ASC)
CREATE INDEX F0101_5 ON F0101 (ABAT1 ASC, ABDC ASC)
CREATE INDEX F0101_6 ON F0101 (ABAC01 ASC, ABAC04 ASC, ABDC ASC)
CREATE INDEX F0101_7 ON F0101 (ABAC01 ASC, ABAC03 ASC, ABDC ASC)
CREATE INDEX F0101_8 ON F0101 (ABAC01 ASC, ABAC02 ASC, ABDC ASC)
CREATE INDEX F0101_9 ON F0101 (ABAC01 ASC, ABDC ASC)
CREATE INDEX F0101_10 ON F0101 (ABAT1 ASC, ABAC01 ASC, ABAC04 ASC, ABDC ASC)
CREATE INDEX F0101_11 ON F0101 (ABAT1 ASC, ABAC01 ASC, ABAC03 ASC, ABDC ASC)
CREATE INDEX F0101_12 ON F0101 (ABAT1 ASC, ABAC01 ASC, ABAC02 ASC, ABDC ASC)
CREATE INDEX F0101_13 ON F0101 (ABAT1 ASC, ABAC01 ASC, ABDC ASC)
===================================================================
So Jorge,
No there is not any problem to use this option to RECREATE indexes.
Christian Audet
Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)