18 Dec
Taking Advantage of Relational Technology Part 2
Avoid Inappropriate Tablespace Scans
There are many DB2 access paths available. The most expensive of these is a tablespace scan because it causes DB2 to scan all the entries of a table to retrieve the rows desired by the application. Within most of the system and application performance reviews done at one recent client’s review, there [...]