

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.
Copyright © 2014 CA Technologies.
All rights reserved.
 
|
|