25 Feb
DB2 Performance Summary Part 2
Make sure that you are using the correct database design
Use partitioning for robust tables that play central parts in the processing to help ease locking and encourage parallelism. Also leverage database partition for large tables (over 500,000 rows) which might benefit from spreading out the I/O to different partitions and different devices.
Use database compression for [...]