Unanswered: Any experience with Design Advisor or db2advis ?
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 v126.96.36.199", "s040914", "MI00093", and FixPak "6".