Designing Tables and Indexes for Performance › Table Space Performance Recommendations › Column Ordering

Column Ordering

When defining a table, you can order your columns in specific ways to achieve the following results:

• Reduce CPU consumption when reading and writing columns with variable-length data
• Reduce the amount of logging performed when updating rows

The version of DB2 you are running influences the way you or DB2 organizes your columns.