Tag Archives: Index
Improving Retrieval Times on DB2 Indexes
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 … Continue reading
