Greeting All,
Did you ever use Design Advisor (GUI) or db2advis (cmd line)?

1. They gave me different recommendations on the same WORKLOAD.
2. db2advis gave me two similar indexes:
CREATE UNIQUE INDEX ON "IN_PAGES" ("PAGE_CD" DESC) ALLOW REVERSE SCANS ;
CREATE UNIQUE INDEX ON "IN_PAGES" ("PAGE_CD" ASC) ALLOW REVERSE SCANS ;

Since "REVERSE SCANS" is specified, why we need two of them?

3. db2advis does not allow me to use use option -m M
error: The option 'M' is an unrecognized mode (-m) option

db2level: "DB2 v8.1.0.58", "s040914", "MI00093", and FixPak "6".

Thank you for advise.