These ideas are derived and quoted from “Best practices for tuning DB2 UDB v8.1 and its databases” CREATE INDEX has a number of options that allow for significant performance gains: Optimizing for SELECT: use PCTFREE 0 if index is on a read-only table. Optimizing for ascending or descending ordering: use ALLOW REVERSE SCANS to allow [...]
Tag Archives: Index